APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1078: per_all_assignments_f paf

1074: CURSOR csr_get_agg_info(p_assignment_id IN NUMBER)
1075: IS
1076: SELECT per_information10
1077: FROM per_all_people_f ppf,
1078: per_all_assignments_f paf
1079: WHERE paf.assignment_id = p_assignment_id
1080: and ppf.person_id = paf.person_id
1081: and p_effective_date between
1082: paf.effective_start_date and paf.effective_end_date

Line 1768: per_all_assignments_f paaf

1764: hr_utility.trace('Range Cursor using Payroll Restriction');
1765: sqlstr := 'SELECT DISTINCT ppf.person_id
1766: FROM per_all_people_f ppf,
1767: pay_payroll_actions ppa,
1768: per_all_assignments_f paaf
1769: WHERE ppa.payroll_action_id = :payroll_action_id
1770: AND ppf.business_group_id +0 = ppa.business_group_id
1771: AND paaf.person_id = ppf.person_id
1772: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||

Line 1854: per_all_assignments_f as1

1850: pay_payroll_actions appa2,
1851: pay_assignment_actions act,
1852: pay_assignment_actions act1,
1853: pay_action_interlocks pai,
1854: per_all_assignments_f as1
1855: WHERE ppa.payroll_action_id = p_pact_id
1856: AND appa.consolidation_set_id = p_consolidation_id
1857: AND appa.effective_date BETWEEN
1858: ppa.start_date AND ppa.effective_date

Line 1904: per_all_assignments_f as1,

1900: pay_payroll_actions appa2,
1901: pay_assignment_actions act,
1902: pay_assignment_actions act1,
1903: pay_action_interlocks pai,
1904: per_all_assignments_f as1,
1905: pay_population_ranges ppr
1906: WHERE ppa.payroll_action_id = p_pact_id
1907: AND appa.consolidation_set_id = p_consolidation_id
1908: AND appa.effective_date BETWEEN