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_CWB_UTILS dependencies on PER_PAY_PROPOSALS

Line 1714: from per_pay_proposals ppp ,ben_cwb_person_rates rts

1710: l_proposed_salary number := 0;
1711:
1712: cursor c_pay_proposal is
1713: select max(nvl(proposed_salary_n,0))
1714: from per_pay_proposals ppp ,ben_cwb_person_rates rts
1715: where rts.pay_proposal_id = ppp.pay_proposal_id
1716: and rts.group_per_in_ler_id = p_group_per_in_ler_id
1717: and rts.group_pl_id = p_group_plan_id
1718: and rts.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt

Line 1827: from per_pay_proposals ppp

1823:
1824: -- return the comp_posting_date
1825: cursor c_pay_proposal_date is
1826: select max(change_date)
1827: from per_pay_proposals ppp
1828: ,ben_cwb_person_rates rts
1829: where rts.pay_proposal_id = ppp.pay_proposal_id
1830: and rts.group_per_in_ler_id = p_group_per_in_ler_id
1831: and rts.group_pl_id = p_group_plan_id