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 PAY_INPUT_VALUES_F

Line 279: pay_input_values_f piv

275: ptp.time_period_id,
276: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
277: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
278: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
279: pay_input_values_f piv
280: WHERE a.assignment_action_id = l_assignment_action_id and
281: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
282: not exists ( select null
283: from pay_element_entries_f pee

Line 321: pay_input_values_f piv

317: ptp.time_period_id,
318: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
319: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
320: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
321: pay_input_values_f piv
322: WHERE a.assignment_action_id = l_assignment_action_id and
323: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
324: exists ( select null
325: from pay_element_entries_f pee

Line 2453: pay_input_values_f piv,

2449:
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

Line 2478: pay_input_values_f piv,

2474:
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

Line 2516: pay_input_values_f piv,

2512:
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

Line 2878: pay_input_values_f piv,

2874:
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

Line 2903: pay_input_values_f piv,

2899:
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

Line 2959: pay_input_values_f piv,

2955:
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