APPS.PAY_SID_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_prsi_details_f sid
30: , per_all_assignments_f paa
31: where sid.prsi_details_id = p_prsi_details_id
32: and sid.assignment_id = paa.assignment_id
33: and pbg.business_group_id = paa.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_prsi_details_f sid
92: , per_all_assignments_f paa
93: where sid.prsi_details_id = p_prsi_details_id
94: and sid.assignment_id = paa.assignment_id
95: and pbg.business_group_id = paa.business_group_id;
96: --

Line 252: FROM per_all_assignments_f

248: ) IS
249: -- select payroll_id if assignment id exists
250: CURSOR csr_assignment IS
251: SELECT payroll_id
252: FROM per_all_assignments_f
253: WHERE assignment_id = p_assignment_id
254: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
255: --
256: l_payroll_id NUMBER;

Line 625: FROM per_time_periods ptp, pay_all_payrolls_f pap, per_all_assignments_f paa

621: ) RETURN NUMBER IS
622: --
623: CURSOR get_period_info IS
624: SELECT ptp.time_period_id, ptp.start_Date, ptp.end_date
625: FROM per_time_periods ptp, pay_all_payrolls_f pap, per_all_assignments_f paa
626: WHERE ptp.payroll_id = pap.payroll_id
627: AND p_effective_date BETWEEN ptp.start_date AND ptp.end_date
628: AND pap.payroll_id = paa.payroll_id
629: AND p_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date

Line 879: (p_base_table_name => 'per_all_assignments_f'

875: );
876: --
877: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
878: NOT (dt_api.check_min_max_dates
879: (p_base_table_name => 'per_all_assignments_f'
880: ,p_base_key_column => 'ASSIGNMENT_ID'
881: ,p_base_key_value => p_assignment_id
882: ,p_from_date => p_validation_start_date
883: ,p_to_date => p_validation_end_date))) Then