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 277: pay_input_values_f piv

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

Line 319: pay_input_values_f piv

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

Line 2379: pay_input_values_f piv,

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

Line 2404: pay_input_values_f piv,

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

Line 2442: pay_input_values_f piv,

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

Line 2804: pay_input_values_f piv,

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

Line 2829: pay_input_values_f piv,

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

Line 2885: pay_input_values_f piv,

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