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.HRHIRAPL dependencies on PER_PAY_PROPOSALS

Line 677: from per_pay_proposals

673: --added by amigarg for bug 4882512 start
674:
675: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
676: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
677: from per_pay_proposals
678: where assignment_id=ass_id
679: and approved = 'N'
680: order by change_date desc;
681: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 681: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

677: from per_pay_proposals
678: where assignment_id=ass_id
679: and approved = 'N'
680: order by change_date desc;
681: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
682: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
683: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
684: l_dummy_change_date per_pay_proposals.change_date%TYPE;
685: l_inv_next_sal_date_warning boolean := false;

Line 682: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;

678: where assignment_id=ass_id
679: and approved = 'N'
680: order by change_date desc;
681: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
682: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
683: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
684: l_dummy_change_date per_pay_proposals.change_date%TYPE;
685: l_inv_next_sal_date_warning boolean := false;
686: l_proposed_salary_warning boolean := false;

Line 683: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

679: and approved = 'N'
680: order by change_date desc;
681: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
682: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
683: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
684: l_dummy_change_date per_pay_proposals.change_date%TYPE;
685: l_inv_next_sal_date_warning boolean := false;
686: l_proposed_salary_warning boolean := false;
687: l_approved_warning boolean := false;

Line 684: l_dummy_change_date per_pay_proposals.change_date%TYPE;

680: order by change_date desc;
681: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
682: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
683: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
684: l_dummy_change_date per_pay_proposals.change_date%TYPE;
685: l_inv_next_sal_date_warning boolean := false;
686: l_proposed_salary_warning boolean := false;
687: l_approved_warning boolean := false;
688: l_payroll_warning boolean := false;

Line 2674: from per_pay_proposals

2670: -- Added for the bug 6512520 starts here
2671:
2672: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
2673: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2674: from per_pay_proposals
2675: where assignment_id=ass_id
2676: and approved = 'N'
2677: order by change_date desc;
2678:

Line 2681: from per_pay_proposals

2677: order by change_date desc;
2678:
2679: cursor get_pay_proposal_emp(ass_id per_all_assignments_f.assignment_id%type) is
2680: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2681: from per_pay_proposals
2682: where assignment_id=ass_id
2683: and approved = 'N'
2684: order by change_date desc;
2685:

Line 2686: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

2682: where assignment_id=ass_id
2683: and approved = 'N'
2684: order by change_date desc;
2685:
2686: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;

2683: and approved = 'N'
2684: order by change_date desc;
2685:
2686: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;

Line 2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

2684: order by change_date desc;
2685:
2686: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

Line 2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;

2685:
2686: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2693: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;

Line 2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

2686: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2693: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2694: l_emp_next_sal_date_warning boolean := false;

Line 2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;

2687: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2693: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2694: l_emp_next_sal_date_warning boolean := false;
2695: l_emp_proposed_salary_warning boolean := false;

Line 2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

2688: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2693: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2694: l_emp_next_sal_date_warning boolean := false;
2695: l_emp_proposed_salary_warning boolean := false;
2696: l_emp_approved_warning boolean := false;

Line 2693: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;

2689: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2690: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2691: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2692: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2693: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2694: l_emp_next_sal_date_warning boolean := false;
2695: l_emp_proposed_salary_warning boolean := false;
2696: l_emp_approved_warning boolean := false;
2697: l_emp_payroll_warning boolean := false;