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 2433: -- Get salary details from per_pay_proposals

2429: x_time_period_id IN NUMBER,
2430: x_element_type_id IN NUMBER,
2431: x_return_status OUT NOCOPY VARCHAR2) IS
2432:
2433: -- Get salary details from per_pay_proposals
2434: /*
2435: CURSOR get_proposal_csr is
2436: SELECT distinct proposed_salary, previous_salary,
2437: change_date,last_change_date,pay_basis

Line 2438: FROM per_pay_proposals_v

2434: /*
2435: CURSOR get_proposal_csr is
2436: SELECT distinct proposed_salary, previous_salary,
2437: change_date,last_change_date,pay_basis
2438: FROM per_pay_proposals_v
2439: WHERE assignment_id = x_assignment_id and
2440: element_type_id = x_element_type_id and
2441: approved='Y' and
2442: change_date between (trunc(g_start_date)+1) and g_end_date

Line 2452: from per_pay_proposals ppp,

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

Line 2477: from per_pay_proposals ppp,

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

Line 2501: FROM per_pay_proposals_v

2497:
2498: /*
2499: CURSOR get_previous_proposal_csr is
2500: SELECT distinct proposed_salary, change_date, pay_basis
2501: FROM per_pay_proposals_v
2502: WHERE assignment_id = x_assignment_id and
2503: element_type_id = x_element_type_id and
2504: change_date <= g_start_date and
2505: approved = 'Y' order by change_date desc ;

Line 2508: -- from per_pay_proposals_v

2504: change_date <= g_start_date and
2505: approved = 'Y' order by change_date desc ;
2506: -- and
2507: -- change_date = (select max(change_date)
2508: -- from per_pay_proposals_v
2509: -- where assignment_id = x_assignment_id and
2510: -- change_date <= g_start_date and approved = 'Y');
2511: */
2512:

Line 2515: from per_pay_proposals ppp,

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

Line 2529: from per_pay_proposals ppp1

2525: and ppp.approved = 'Y'
2526: --and ppp.change_date <= :g_start_date
2527: and ppp.change_date =
2528: (select max(change_date)
2529: from per_pay_proposals ppp1
2530: where ppp1.assignment_id = x_assignment_id
2531: and ppp1.approved = 'Y'
2532: and ppp1.change_date <= g_start_date)
2533: --and ppb.pay_basis_id = :p_pay_basis_id

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

2614: -- raise NO_DATA_FOUND;
2615: -- exit;
2616: end if;
2617: close get_proposal_prevsal_csr;
2618: --dbms_output.PUT_LINE(' There is a record in per_pay_proposals' );
2619: ----dbms_output.PUT_LINE('Proposed Salary ' || get_proposal_rec.proposed_salary);
2620: ----dbms_output.PUT_LINE('Previous Salary ' || get_proposal_prevsal_rec.previous_salary);
2621: ----dbms_output.PUT_LINE('Change Date ' || to_char(get_proposal_rec.change_date,'YYYY/MM/DD'));
2622: --dbms_output.PUT_LINE('L Change Date ' || to_char(get_proposal_rec.last_change_date,'YYYY/MM/DD'));

Line 2865: FROM per_pay_proposals_v

2861: previous_salary,
2862: change_date,
2863: last_change_date,
2864: pay_basis
2865: FROM per_pay_proposals_v
2866: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2867: element_type_id = g_payroll_line_rec.element_type_id and
2868: approved = 'Y' and
2869: change_date between (trunc(g_start_date)+1) and g_end_date

Line 2877: from per_pay_proposals ppp,

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

Line 2902: from per_pay_proposals ppp,

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

Line 2936: FROM per_pay_proposals_v

2932: /*
2933:
2934: CURSOR get_previous_proposal_csr is
2935: SELECT change_date, proposed_salary
2936: FROM per_pay_proposals_v
2937: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2938: element_type_id = g_payroll_line_rec.element_type_id and
2939: change_date <= g_start_date and
2940: approved = 'Y' and

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

2937: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2938: element_type_id = g_payroll_line_rec.element_type_id and
2939: change_date <= g_start_date and
2940: approved = 'Y' and
2941: change_date = (select max(change_date) from per_pay_proposals_v
2942: where assignment_id = g_payroll_line_rec.assignment_id and
2943: change_date <= g_start_date and approved = 'Y')
2944: ORDER BY change_date;
2945:

Line 2948: FROM per_pay_proposals_v

2944: ORDER BY change_date;
2945:
2946: CURSOR get_previous_proposal_csr is
2947: SELECT proposed_salary, change_date,pay_basis
2948: FROM per_pay_proposals_v
2949: WHERE assignment_id = g_payroll_line_rec.assignment_id and
2950: element_type_id = g_payroll_line_rec.element_type_id and
2951: change_date <= g_start_date and
2952: approved = 'Y'

Line 2958: from per_pay_proposals ppp,

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

Line 2972: from per_pay_proposals ppp1

2968: and ppp.approved = 'Y'
2969: --and ppp.change_date <= :g_start_date
2970: and ppp.change_date =
2971: (select max(change_date)
2972: from per_pay_proposals ppp1
2973: where ppp1.assignment_id = g_payroll_line_rec.assignment_id
2974: and ppp1.approved = 'Y'
2975: and ppp1.change_date <= g_start_date)
2976: --and ppb.pay_basis_id = :p_pay_basis_id