APPS.PAY_DK_SOE dependencies on PER_ALL_ASSIGNMENTS_F

Line 10: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

6: -----------------------------------------------------------------------------------------
7: -- function for fetching the Legal Entity CVR Number or Pension Provider
8:
9: FUNCTION get_cvr_or_pension
10: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
11: p_effective_date IN Date,
12: p_org_information_context IN VARCHAR2 )
13: return VARCHAR2
14:

Line 59: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

55:
56: -- function for fetching the Union Membership
57:
58: FUNCTION get_union_membership
59: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
60: p_effective_date IN Date )
61: return varchar2
62:
63: IS

Line 70: from per_all_assignments_f asg

66: BEGIN
67:
68: select lkp.meaning
69: into l_union_membership
70: from per_all_assignments_f asg
71: ,hr_soft_coding_keyflex scl
72: ,hr_lookups lkp
73: where lkp.lookup_type = 'DK_UNION_MEMBERSHIP'
74: and lkp.lookup_code = scl.segment5

Line 163: ,per_all_assignments_f asg

159: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_LEGAL_ENTITY_DETAILS''), '''') COL17
160: ,nvl(pay_dk_soe.get_cvr_or_pension(:assignment_id,:effective_date,''DK_PENSION_PROVIDER_DETAILS''), '''') COL18
161: ,nvl(pay_dk_soe.get_union_membership(:assignment_id,:effective_date), '''') COL19
162: from per_all_people_f peo
163: ,per_all_assignments_f asg
164: ,hr_all_organization_units_vl org
165: ,per_jobs_vl job
166: ,per_all_positions pos
167: ,hr_locations loc