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 5548: from per_pay_proposals b

5544: --
5545: cursor c_old_sal(p_assignment_id number,p_change_date date) is
5546: select
5547: proposed_salary_n, approved
5548: from per_pay_proposals b
5549: where
5550: b.assignment_id = p_assignment_id
5551: and b.change_date =
5552: (select max(d.change_date)

Line 5553: from per_pay_proposals d

5549: where
5550: b.assignment_id = p_assignment_id
5551: and b.change_date =
5552: (select max(d.change_date)
5553: from per_pay_proposals d
5554: where d.assignment_id = b.assignment_id
5555: and approved = 'Y'
5556: and change_date < p_change_date )
5557: ;

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

5558:
5559:
5560: l_person_id number ;
5561: l_business_group_id number ;
5562: l_old_proposed_salary_n per_pay_proposals.proposed_salary_n%type := p_old_rec.proposed_salary_n;
5563: l_old_approved per_pay_proposals.approved%type ;
5564: --
5565: begin
5566: --

Line 5563: l_old_approved per_pay_proposals.approved%type ;

5559:
5560: l_person_id number ;
5561: l_business_group_id number ;
5562: l_old_proposed_salary_n per_pay_proposals.proposed_salary_n%type := p_old_rec.proposed_salary_n;
5563: l_old_approved per_pay_proposals.approved%type ;
5564: --
5565: begin
5566: --
5567: