APPS.PAY_DK_SOE dependencies on PER_ALL_ASSIGNMENTS_F

Line 8: cursor csr_get_cvr_number (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is

4: --
5:
6: -- cursor to get the CVR Number
7:
8: cursor csr_get_cvr_number (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is
9: select hoi.org_information1
10: from hr_soft_coding_keyflex sck
11: ,HR_ORGANIZATION_INFORMATION hoi
12: ,per_all_assignments_f paa

Line 12: ,per_all_assignments_f paa

8: cursor csr_get_cvr_number (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is
9: select hoi.org_information1
10: from hr_soft_coding_keyflex sck
11: ,HR_ORGANIZATION_INFORMATION hoi
12: ,per_all_assignments_f paa
13: where paa.assignment_id = p_assignment_id
14: and p_effective_date between paa.effective_start_date and paa.effective_end_date
15: and paa.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
16: and hoi.organization_id = to_number(sck.segment1)

Line 21: cursor csr_get_pension_provider (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is

17: and hoi.org_information_context = 'DK_LEGAL_ENTITY_DETAILS';
18:
19: -- cursor to get the Pension Provider
20:
21: cursor csr_get_pension_provider (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is
22: select hou.name
23: from hr_soft_coding_keyflex sck
24: ,HR_ORGANIZATION_INFORMATION hoi
25: ,per_all_assignments_f paa

Line 25: ,per_all_assignments_f paa

21: cursor csr_get_pension_provider (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is
22: select hou.name
23: from hr_soft_coding_keyflex sck
24: ,HR_ORGANIZATION_INFORMATION hoi
25: ,per_all_assignments_f paa
26: ,HR_ORGANIZATION_UNITS hou
27: where paa.assignment_id = p_assignment_id
28: and p_effective_date between paa.effective_start_date and paa.effective_end_date
29: and paa.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

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

34:
35: -- function for fetching the Legal Entity CVR Number or Pension Provider
36:
37: FUNCTION get_cvr_or_pension
38: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
39: p_effective_date IN Date,
40: p_org_information_context IN VARCHAR2 )
41: return VARCHAR2;
42:

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

42:
43: -- function for fetching the Union Membership
44:
45: FUNCTION get_union_membership
46: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
47: p_effective_date IN Date )
48: return varchar2;
49:
50: