APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1011: per_all_assignments_f paf

1007: CURSOR csr_get_agg_info(p_assignment_id IN NUMBER)
1008: IS
1009: SELECT per_information10
1010: FROM per_all_people_f ppf,
1011: per_all_assignments_f paf
1012: WHERE paf.assignment_id = p_assignment_id
1013: and ppf.person_id = paf.person_id
1014: and p_effective_date between
1015: paf.effective_start_date and paf.effective_end_date

Line 1701: per_all_assignments_f paaf

1697: hr_utility.trace('Range Cursor using Payroll Restriction');
1698: sqlstr := 'SELECT DISTINCT ppf.person_id
1699: FROM per_all_people_f ppf,
1700: pay_payroll_actions ppa,
1701: per_all_assignments_f paaf
1702: WHERE ppa.payroll_action_id = :payroll_action_id
1703: AND ppf.business_group_id +0 = ppa.business_group_id
1704: AND paaf.person_id = ppf.person_id
1705: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||

Line 1787: per_all_assignments_f as1

1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,
1786: pay_action_interlocks pai,
1787: per_all_assignments_f as1
1788: WHERE ppa.payroll_action_id = p_pact_id
1789: AND appa.consolidation_set_id = p_consolidation_id
1790: AND appa.effective_date BETWEEN
1791: ppa.start_date AND ppa.effective_date

Line 1835: per_all_assignments_f as1,

1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,
1835: per_all_assignments_f as1,
1836: pay_population_ranges ppr
1837: WHERE ppa.payroll_action_id = p_pact_id
1838: AND appa.consolidation_set_id = p_consolidation_id
1839: AND appa.effective_date BETWEEN