APPS.PSP_PAYTRN dependencies on PER_ALL_ASSIGNMENTS_F

Line 842: FROM per_all_assignments_f

838: l_assignment_action_id:=g_payroll_asg_rec.assignment_action_id;
839:
840: SELECT DISTINCT person_id
841: INTO l_person_id
842: FROM per_all_assignments_f
843: WHERE assignment_id = l_assignment_id;
844:
845:
846:

Line 2455: per_all_assignments_f paf

2451: select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
2452: from per_pay_proposals ppp,
2453: pay_input_values_f piv,
2454: per_pay_bases ppb,
2455: per_all_assignments_f paf
2456: where paf.assignment_id = x_assignment_id
2457: and ppp.change_date between paf.effective_start_date and
2458: paf.effective_end_date
2459: and paf.pay_basis_id = ppb.pay_basis_id

Line 2480: per_all_assignments_f paf

2476: select ppp.proposed_salary_n previous_salary, ppp.change_date last_change_date
2477: from per_pay_proposals ppp,
2478: pay_input_values_f piv,
2479: per_pay_bases ppb,
2480: per_all_assignments_f paf
2481: where paf.assignment_id = x_assignment_id
2482: and ppp.change_date between paf.effective_start_date and
2483: paf.effective_end_date
2484: and paf.pay_basis_id = ppb.pay_basis_id

Line 2518: per_all_assignments_f paf

2514: select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
2515: from per_pay_proposals ppp,
2516: pay_input_values_f piv,
2517: per_pay_bases ppb,
2518: per_all_assignments_f paf
2519: where paf.assignment_id =x_assignment_id
2520: and ppp.change_date between paf.effective_start_date and
2521: paf.effective_end_date
2522: and paf.pay_basis_id = ppb.pay_basis_id

Line 2880: per_all_assignments_f paf

2876: select distinct ppp.proposed_salary_n proposed_salary, ppp.change_date
2877: from per_pay_proposals ppp,
2878: pay_input_values_f piv,
2879: per_pay_bases ppb,
2880: per_all_assignments_f paf
2881: where paf.assignment_id = g_payroll_line_rec.assignment_id
2882: and ppp.change_date between paf.effective_start_date and
2883: paf.effective_end_date
2884: and paf.pay_basis_id = ppb.pay_basis_id

Line 2905: per_all_assignments_f paf

2901: select ppp.proposed_salary_n previous_salary, ppp.change_date last_change_date
2902: from per_pay_proposals ppp,
2903: pay_input_values_f piv,
2904: per_pay_bases ppb,
2905: per_all_assignments_f paf
2906: where paf.assignment_id = g_payroll_line_rec.assignment_id
2907: and ppp.change_date between paf.effective_start_date and
2908: paf.effective_end_date
2909: and paf.pay_basis_id = ppb.pay_basis_id

Line 2961: per_all_assignments_f paf

2957: select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
2958: from per_pay_proposals ppp,
2959: pay_input_values_f piv,
2960: per_pay_bases ppb,
2961: per_all_assignments_f paf
2962: where paf.assignment_id =g_payroll_line_rec.assignment_id
2963: and ppp.change_date between paf.effective_start_date and
2964: paf.effective_end_date
2965: and paf.pay_basis_id = ppb.pay_basis_id