APPS.PSP_PAYTRN dependencies on PER_ALL_ASSIGNMENTS_F

Line 839: FROM per_all_assignments_f

835: l_assignment_action_id:=g_payroll_asg_rec.assignment_action_id;
836:
837: SELECT DISTINCT person_id
838: INTO l_person_id
839: FROM per_all_assignments_f
840: WHERE assignment_id = l_assignment_id;
841:
842:
843:

Line 2381: per_all_assignments_f paf

2377: select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
2378: from per_pay_proposals ppp,
2379: pay_input_values_f piv,
2380: per_pay_bases ppb,
2381: per_all_assignments_f paf
2382: where paf.assignment_id = x_assignment_id
2383: and ppp.change_date between paf.effective_start_date and
2384: paf.effective_end_date
2385: and paf.pay_basis_id = ppb.pay_basis_id

Line 2406: per_all_assignments_f paf

2402: select ppp.proposed_salary_n previous_salary, ppp.change_date last_change_date
2403: from per_pay_proposals ppp,
2404: pay_input_values_f piv,
2405: per_pay_bases ppb,
2406: per_all_assignments_f paf
2407: where paf.assignment_id = x_assignment_id
2408: and ppp.change_date between paf.effective_start_date and
2409: paf.effective_end_date
2410: and paf.pay_basis_id = ppb.pay_basis_id

Line 2444: per_all_assignments_f paf

2440: select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
2441: from per_pay_proposals ppp,
2442: pay_input_values_f piv,
2443: per_pay_bases ppb,
2444: per_all_assignments_f paf
2445: where paf.assignment_id =x_assignment_id
2446: and ppp.change_date between paf.effective_start_date and
2447: paf.effective_end_date
2448: and paf.pay_basis_id = ppb.pay_basis_id

Line 2806: per_all_assignments_f paf

2802: select distinct ppp.proposed_salary_n proposed_salary, ppp.change_date
2803: from per_pay_proposals ppp,
2804: pay_input_values_f piv,
2805: per_pay_bases ppb,
2806: per_all_assignments_f paf
2807: where paf.assignment_id = g_payroll_line_rec.assignment_id
2808: and ppp.change_date between paf.effective_start_date and
2809: paf.effective_end_date
2810: and paf.pay_basis_id = ppb.pay_basis_id

Line 2831: per_all_assignments_f paf

2827: select ppp.proposed_salary_n previous_salary, ppp.change_date last_change_date
2828: from per_pay_proposals ppp,
2829: pay_input_values_f piv,
2830: per_pay_bases ppb,
2831: per_all_assignments_f paf
2832: where paf.assignment_id = g_payroll_line_rec.assignment_id
2833: and ppp.change_date between paf.effective_start_date and
2834: paf.effective_end_date
2835: and paf.pay_basis_id = ppb.pay_basis_id

Line 2887: per_all_assignments_f paf

2883: select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
2884: from per_pay_proposals ppp,
2885: pay_input_values_f piv,
2886: per_pay_bases ppb,
2887: per_all_assignments_f paf
2888: where paf.assignment_id =g_payroll_line_rec.assignment_id
2889: and ppp.change_date between paf.effective_start_date and
2890: paf.effective_end_date
2891: and paf.pay_basis_id = ppb.pay_basis_id