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

Line 5644: from per_pay_proposals b

5640: --
5641: cursor c_old_sal(p_assignment_id number,p_change_date date) is
5642: select
5643: proposed_salary_n, approved
5644: from per_pay_proposals b
5645: where
5646: b.assignment_id = p_assignment_id
5647: and b.change_date =
5648: (select max(d.change_date)

Line 5649: from per_pay_proposals d

5645: where
5646: b.assignment_id = p_assignment_id
5647: and b.change_date =
5648: (select max(d.change_date)
5649: from per_pay_proposals d
5650: where d.assignment_id = b.assignment_id
5651: and approved = 'Y'
5652: and change_date < p_change_date )
5653: ;

Line 5658: l_old_proposed_salary_n per_pay_proposals.proposed_salary_n%type := p_old_rec.proposed_salary_n;

5654:
5655:
5656: l_person_id number ;
5657: l_business_group_id number ;
5658: l_old_proposed_salary_n per_pay_proposals.proposed_salary_n%type := p_old_rec.proposed_salary_n;
5659: l_old_approved per_pay_proposals.approved%type ;
5660: --
5661: begin
5662: --

Line 5659: l_old_approved per_pay_proposals.approved%type ;

5655:
5656: l_person_id number ;
5657: l_business_group_id number ;
5658: l_old_proposed_salary_n per_pay_proposals.proposed_salary_n%type := p_old_rec.proposed_salary_n;
5659: l_old_approved per_pay_proposals.approved%type ;
5660: --
5661: begin
5662: --
5663: