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_PROPOSALS

Line 2359: -- Get salary details from per_pay_proposals

2355: x_time_period_id IN NUMBER,
2356: x_element_type_id IN NUMBER,
2357: x_return_status OUT NOCOPY VARCHAR2) IS
2358:
2359: -- Get salary details from per_pay_proposals
2360: /*
2361: CURSOR get_proposal_csr is
2362: SELECT distinct proposed_salary, previous_salary,
2363: change_date,last_change_date,pay_basis

Line 2364: FROM per_pay_proposals_v

2360: /*
2361: CURSOR get_proposal_csr is
2362: SELECT distinct proposed_salary, previous_salary,
2363: change_date,last_change_date,pay_basis
2364: FROM per_pay_proposals_v
2365: WHERE assignment_id = x_assignment_id and
2366: element_type_id = x_element_type_id and
2367: approved='Y' and
2368: change_date between (trunc(g_start_date)+1) and g_end_date

Line 2378: from per_pay_proposals ppp,

2374: */
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

Line 2403: from per_pay_proposals ppp,

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

Line 2427: FROM per_pay_proposals_v

2423:
2424: /*
2425: CURSOR get_previous_proposal_csr is
2426: SELECT distinct proposed_salary, change_date, pay_basis
2427: FROM per_pay_proposals_v
2428: WHERE assignment_id = x_assignment_id and
2429: element_type_id = x_element_type_id and
2430: change_date <= g_start_date and
2431: approved = 'Y' order by change_date desc ;

Line 2434: -- from per_pay_proposals_v

2430: change_date <= g_start_date and
2431: approved = 'Y' order by change_date desc ;
2432: -- and
2433: -- change_date = (select max(change_date)
2434: -- from per_pay_proposals_v
2435: -- where assignment_id = x_assignment_id and
2436: -- change_date <= g_start_date and approved = 'Y');
2437: */
2438:

Line 2441: from per_pay_proposals ppp,

2437: */
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

Line 2455: from per_pay_proposals ppp1

2451: and ppp.approved = 'Y'
2452: --and ppp.change_date <= :g_start_date
2453: and ppp.change_date =
2454: (select max(change_date)
2455: from per_pay_proposals ppp1
2456: where ppp1.assignment_id = x_assignment_id
2457: and ppp1.approved = 'Y'
2458: and ppp1.change_date <= g_start_date)
2459: --and ppb.pay_basis_id = :p_pay_basis_id

Line 2544: --dbms_output.PUT_LINE(' There is a record in per_pay_proposals' );

2540: -- raise NO_DATA_FOUND;
2541: -- exit;
2542: end if;
2543: close get_proposal_prevsal_csr;
2544: --dbms_output.PUT_LINE(' There is a record in per_pay_proposals' );
2545: ----dbms_output.PUT_LINE('Proposed Salary ' || get_proposal_rec.proposed_salary);
2546: ----dbms_output.PUT_LINE('Previous Salary ' || get_proposal_prevsal_rec.previous_salary);
2547: ----dbms_output.PUT_LINE('Change Date ' || to_char(get_proposal_rec.change_date,'YYYY/MM/DD'));
2548: --dbms_output.PUT_LINE('L Change Date ' || to_char(get_proposal_rec.last_change_date,'YYYY/MM/DD'));

Line 2791: FROM per_pay_proposals_v

2787: previous_salary,
2788: change_date,
2789: last_change_date,
2790: pay_basis
2791: FROM per_pay_proposals_v
2792: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2793: element_type_id = g_payroll_line_rec.element_type_id and
2794: approved = 'Y' and
2795: change_date between (trunc(g_start_date)+1) and g_end_date

Line 2803: from per_pay_proposals ppp,

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

Line 2828: from per_pay_proposals ppp,

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

Line 2862: FROM per_pay_proposals_v

2858: /*
2859:
2860: CURSOR get_previous_proposal_csr is
2861: SELECT change_date, proposed_salary
2862: FROM per_pay_proposals_v
2863: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2864: element_type_id = g_payroll_line_rec.element_type_id and
2865: change_date <= g_start_date and
2866: approved = 'Y' and

Line 2867: change_date = (select max(change_date) from per_pay_proposals_v

2863: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2864: element_type_id = g_payroll_line_rec.element_type_id and
2865: change_date <= g_start_date and
2866: approved = 'Y' and
2867: change_date = (select max(change_date) from per_pay_proposals_v
2868: where assignment_id = g_payroll_line_rec.assignment_id and
2869: change_date <= g_start_date and approved = 'Y')
2870: ORDER BY change_date;
2871:

Line 2874: FROM per_pay_proposals_v

2870: ORDER BY change_date;
2871:
2872: CURSOR get_previous_proposal_csr is
2873: SELECT proposed_salary, change_date,pay_basis
2874: FROM per_pay_proposals_v
2875: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2876: element_type_id = g_payroll_line_rec.element_type_id and
2877: change_date <= g_start_date and
2878: approved = 'Y'

Line 2884: from per_pay_proposals ppp,

2880: */
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

Line 2898: from per_pay_proposals ppp1

2894: and ppp.approved = 'Y'
2895: --and ppp.change_date <= :g_start_date
2896: and ppp.change_date =
2897: (select max(change_date)
2898: from per_pay_proposals ppp1
2899: where ppp1.assignment_id = g_payroll_line_rec.assignment_id
2900: and ppp1.approved = 'Y'
2901: and ppp1.change_date <= g_start_date)
2902: --and ppb.pay_basis_id = :p_pay_basis_id