eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PAYTRN dependencies on PER_PAY_BASES

Line 2380: per_pay_bases ppb,

2376: CURSOR get_proposal_csr is
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

Line 2405: per_pay_bases ppb,

2401: CURSOR get_proposal_prevsal_csr(p_change_date in date ) is
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

Line 2443: per_pay_bases ppb,

2439: CURSOR get_previous_proposal_csr is
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

Line 2805: per_pay_bases ppb,

2801: CURSOR get_proposal_csr is
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

Line 2830: per_pay_bases ppb,

2826: CURSOR get_proposal_prevsal_csr(p_change_date in date ) is
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

Line 2886: per_pay_bases ppb,

2882: CURSOR get_previous_proposal_csr is
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