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 2454: per_pay_bases ppb,

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

Line 2479: per_pay_bases ppb,

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

Line 2517: per_pay_bases ppb,

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

Line 2879: per_pay_bases ppb,

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

Line 2904: per_pay_bases ppb,

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

Line 2960: per_pay_bases ppb,

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