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.

[Home] [Help]

APPS.HRHIRAPL dependencies on PER_PAY_PROPOSALS

Line 134: l_proposal_id per_pay_proposals.pay_proposal_id%type;

130: and business_group_id = p_business_group_id
131: and primary_flag = 'Y'
132: and p_start_date between effective_start_date and effective_end_date;
133:
134: l_proposal_id per_pay_proposals.pay_proposal_id%type;
135: l_proposal_exists varchar2(1);
136:
137: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
138: select pay_proposal_id

Line 139: from per_pay_proposals

135: l_proposal_exists varchar2(1);
136:
137: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
138: select pay_proposal_id
139: from per_pay_proposals
140: where assignment_id=ass_id
141: and APPROVED='Y';
142:
143: function table_contents return varchar2 is

Line 700: from per_pay_proposals

696: --added by amigarg for bug 4882512 start
697:
698: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
699: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
700: from per_pay_proposals
701: where assignment_id=ass_id
702: and approved = 'N'
703: order by change_date desc;
704: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 704: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

700: from per_pay_proposals
701: where assignment_id=ass_id
702: and approved = 'N'
703: order by change_date desc;
704: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
705: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
706: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
707: l_dummy_change_date per_pay_proposals.change_date%TYPE;
708: l_inv_next_sal_date_warning boolean := false;

Line 705: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;

701: where assignment_id=ass_id
702: and approved = 'N'
703: order by change_date desc;
704: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
705: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
706: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
707: l_dummy_change_date per_pay_proposals.change_date%TYPE;
708: l_inv_next_sal_date_warning boolean := false;
709: l_proposed_salary_warning boolean := false;

Line 706: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

702: and approved = 'N'
703: order by change_date desc;
704: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
705: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
706: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
707: l_dummy_change_date per_pay_proposals.change_date%TYPE;
708: l_inv_next_sal_date_warning boolean := false;
709: l_proposed_salary_warning boolean := false;
710: l_approved_warning boolean := false;

Line 707: l_dummy_change_date per_pay_proposals.change_date%TYPE;

703: order by change_date desc;
704: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
705: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
706: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
707: l_dummy_change_date per_pay_proposals.change_date%TYPE;
708: l_inv_next_sal_date_warning boolean := false;
709: l_proposed_salary_warning boolean := false;
710: l_approved_warning boolean := false;
711: l_payroll_warning boolean := false;

Line 2778: from per_pay_proposals

2774: -- Added for the bug 6512520 starts here
2775:
2776: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
2777: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2778: from per_pay_proposals
2779: where assignment_id=ass_id
2780: and approved = 'N'
2781: order by change_date desc;
2782:

Line 2785: from per_pay_proposals

2781: order by change_date desc;
2782:
2783: cursor get_pay_proposal_emp(ass_id per_all_assignments_f.assignment_id%type) is
2784: select pay_proposal_id,object_version_number,proposed_salary_n, change_date
2785: from per_pay_proposals
2786: where assignment_id=ass_id
2787: and approved = 'N'
2788: order by change_date desc;
2789:

Line 2790: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

2786: where assignment_id=ass_id
2787: and approved = 'N'
2788: order by change_date desc;
2789:
2790: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;

2787: and approved = 'N'
2788: order by change_date desc;
2789:
2790: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;

Line 2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

2788: order by change_date desc;
2789:
2790: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

Line 2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;

2789:
2790: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2797: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;

Line 2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

2790: l_apl_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2797: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2798: l_emp_next_sal_date_warning boolean := false;

Line 2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;

2791: l_apl_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2797: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2798: l_emp_next_sal_date_warning boolean := false;
2799: l_emp_proposed_salary_warning boolean := false;

Line 2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

2792: l_apl_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2797: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2798: l_emp_next_sal_date_warning boolean := false;
2799: l_emp_proposed_salary_warning boolean := false;
2800: l_emp_approved_warning boolean := false;

Line 2797: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;

2793: l_apl_dummy_change_date per_pay_proposals.change_date%TYPE;
2794: l_emp_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
2795: l_emp_pay_obj_number per_pay_proposals.object_version_number%TYPE;
2796: l_emp_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
2797: l_emp_dummy_change_date per_pay_proposals.change_date%TYPE;
2798: l_emp_next_sal_date_warning boolean := false;
2799: l_emp_proposed_salary_warning boolean := false;
2800: l_emp_approved_warning boolean := false;
2801: l_emp_payroll_warning boolean := false;