DBA Data[Home] [Help]

APPS.PAY_ASG_GEO_PKG dependencies on PER_ASSIGNMENTS_F

Line 15: FROM per_assignments_f

11: IS
12:
13: CURSOR csr_date IS
14: SELECT effective_start_date, effective_end_date
15: FROM per_assignments_f
16: WHERE assignment_id = P_assignment_id;
17:
18: CURSOR csr_date_and_gre IS
19: SELECT distinct --Bug 4671218 paf.effective_start_date, paf.effective_end_date,

Line 21: FROM per_assignments_f paf, hr_soft_coding_keyflex hsck

17:
18: CURSOR csr_date_and_gre IS
19: SELECT distinct --Bug 4671218 paf.effective_start_date, paf.effective_end_date,
20: hsck.segment1 tax_unit_id
21: FROM per_assignments_f paf, hr_soft_coding_keyflex hsck
22: WHERE paf.assignment_id = P_assignment_id
23: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
24:
25: v_tax_unit_id NUMBER;