APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 1082: per_assignments_f paf,

1078: IS
1079: CURSOR csr_first_name IS
1080: SELECT substr(papf.first_name||' '||papf.middle_names,1,20)
1081: FROM per_people_f papf,
1082: per_assignments_f paf,
1083: pay_assignment_actions paa,
1084: pay_payroll_actions ppa
1085: WHERE paa.assignment_action_id = p_run_assignment_action_id
1086: AND paf.assignment_id = paa.assignment_id

Line 1121: per_assignments_f paf,

1117: IS
1118: CURSOR csr_last_name is
1119: SELECT substr(papf.last_name,1,20)
1120: FROM per_people_f papf,
1121: per_assignments_f paf,
1122: pay_assignment_actions paa,
1123: pay_payroll_actions ppa
1124: WHERE paa.assignment_action_id = p_run_assignment_action_id
1125: AND paf.assignment_id = paa.assignment_id

Line 1161: per_assignments_f paf,

1157: -- Used per_all_assignments_f 4555600
1158: CURSOR csr_dob IS
1159: SELECT to_char(papf.date_of_birth,'dd-mon-yyyy')
1160: FROM per_people_f papf,
1161: per_assignments_f paf,
1162: pay_assignment_actions paa,
1163: pay_payroll_actions ppa
1164: WHERE paa.assignment_action_id = p_run_assignment_action_id
1165: AND paf.assignment_id = paa.assignment_id

Line 2059: per_assignments_f asg,

2055: -- Used per_all_assignments_f 4555600
2056: hr_utility.trace('Range Cursor Not using Payroll Restriction');
2057: sqlstr := 'SELECT distinct asg.person_id
2058: FROM per_periods_of_service pos,
2059: per_assignments_f asg,
2060: pay_payroll_actions ppa
2061: WHERE ppa.payroll_action_id = :payroll_action_id
2062: AND pos.person_id = asg.person_id
2063: AND pos.period_of_service_id = asg.period_of_service_id

Line 2075: per_assignments_f paaf

2071: hr_utility.trace('Range Cursor using Payroll Restriction');
2072: sqlstr := 'SELECT DISTINCT ppf.person_id
2073: FROM per_people_f ppf,
2074: pay_payroll_actions ppa,
2075: per_assignments_f paaf
2076: WHERE ppa.payroll_action_id = :payroll_action_id
2077: AND ppf.business_group_id +0 = ppa.business_group_id
2078: AND paaf.person_id = ppf.person_id
2079: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||

Line 2164: per_assignments_f as1

2160: pay_payroll_actions appa2,
2161: pay_assignment_actions act,
2162: pay_assignment_actions act1,
2163: pay_action_interlocks pai,
2164: per_assignments_f as1
2165: WHERE ppa.payroll_action_id = p_pact_id
2166: AND appa.consolidation_set_id = p_consolidation_id
2167: AND appa.effective_date BETWEEN
2168: ppa.start_date AND ppa.effective_date

Line 2215: per_assignments_f as1,

2211: pay_payroll_actions appa2,
2212: pay_assignment_actions act,
2213: pay_assignment_actions act1,
2214: pay_action_interlocks pai,
2215: per_assignments_f as1,
2216: pay_population_ranges ppr
2217: WHERE ppa.payroll_action_id = p_pact_id
2218: AND appa.consolidation_set_id = p_consolidation_id
2219: AND appa.effective_date BETWEEN