DBA Data[Home] [Help]

APPS.HR_PAY_IF_ELE_ENT_BRD dependencies on HR_PAY_INTERFACE_PKG

Line 16: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate)

12: CURSOR csr_get_pid IS
13: SELECT pa.payroll_id
14: FROM per_all_assignments_f pa
15: WHERE pa.assignment_id = :old.assignment_id AND
16: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate)
17: >= pa.effective_start_date AND
18: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate)
19: <= pa.effective_end_date;
20: CURSOR csr_get_person_id IS

Line 18: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate)

14: FROM per_all_assignments_f pa
15: WHERE pa.assignment_id = :old.assignment_id AND
16: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate)
17: >= pa.effective_start_date AND
18: nvl(HR_PAY_INTERFACE_PKG.g_payroll_extract_date, sysdate)
19: <= pa.effective_end_date;
20: CURSOR csr_get_person_id IS
21: SELECT paa.person_id
22: FROM per_all_assignments_f paa

Line 32: INTO HR_PAY_INTERFACE_PKG.g_element_entry_rec_var.business_group_id;

28: --
29: IF HR_GENERAL.g_data_migrator_mode <> 'Y' THEN
30: OPEN csr_get_bg;
31: FETCH csr_get_bg
32: INTO HR_PAY_INTERFACE_PKG.g_element_entry_rec_var.business_group_id;
33: CLOSE csr_get_bg;
34:
35: OPEN csr_get_pid;
36: FETCH csr_get_pid

Line 37: INTO HR_PAY_INTERFACE_PKG.g_element_entry_rec_var.payroll_id;

33: CLOSE csr_get_bg;
34:
35: OPEN csr_get_pid;
36: FETCH csr_get_pid
37: INTO HR_PAY_INTERFACE_PKG.g_element_entry_rec_var.payroll_id;
38: CLOSE csr_get_pid;
39:
40: OPEN csr_get_person_id;
41: FETCH csr_get_person_id

Line 46: HR_PAY_INTERFACE_PKG.set_ele_var_ids(:old.element_link_id,

42: INTO l_person_id;
43: CLOSE csr_get_person_id;
44: --
45:
46: HR_PAY_INTERFACE_PKG.set_ele_var_ids(:old.element_link_id,
47: :old.element_entry_id,
48: :old.effective_start_date,
49: l_person_id);
50: END IF;