DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on HR_SOFT_CODING_KEYFLEX

Line 10: from hr_soft_coding_keyflex sck

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
13: where paa.assignment_id = p_assignment_id
14: and p_effective_date between paa.effective_start_date and paa.effective_end_date

Line 23: from hr_soft_coding_keyflex sck

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
26: ,HR_ORGANIZATION_UNITS hou
27: where paa.assignment_id = p_assignment_id