APPS.PAY_IPD_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 30: , per_all_assignments_f paa

26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_ie_paye_details_f ipd
30: , per_all_assignments_f paa
31: where ipd.paye_details_id = p_paye_details_id
32: and ipd.assignment_id = paa.assignment_id
33: and paa.business_group_id = pbg.business_group_id;
34: --

Line 92: , per_all_assignments_f paa

88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , pay_ie_paye_details_f ipd
92: , per_all_assignments_f paa
93: where ipd.paye_details_id = p_paye_details_id
94: and ipd.assignment_id = paa.assignment_id
95: and paa.business_group_id = pbg.business_group_id;
96: --

Line 258: FROM per_all_assignments_f

254: ) IS
255: -- select payroll_id if assignment id exists
256: CURSOR csr_assignment IS
257: SELECT payroll_id
258: FROM per_all_assignments_f
259: WHERE assignment_id = p_assignment_id
260: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
261: --
262: l_payroll_id NUMBER;

Line 817: (p_base_table_name => 'per_all_assignments_f'

813: );
814: --
815: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
816: NOT (dt_api.check_min_max_dates
817: (p_base_table_name => 'per_all_assignments_f'
818: ,p_base_key_column => 'ASSIGNMENT_ID'
819: ,p_base_key_value => p_assignment_id
820: ,p_from_date => p_validation_start_date
821: ,p_to_date => p_validation_end_date))) Then