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 2221: from per_pay_proposals ppp ,ben_cwb_person_rates rts

2217: l_proposed_salary number := 0;
2218:
2219: cursor c_pay_proposal is
2220: select max(nvl(proposed_salary_n,0))
2221: from per_pay_proposals ppp ,ben_cwb_person_rates rts
2222: where rts.pay_proposal_id = ppp.pay_proposal_id
2223: and rts.group_per_in_ler_id = p_group_per_in_ler_id
2224: and rts.group_pl_id = p_group_plan_id
2225: and rts.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt

Line 2334: from per_pay_proposals ppp

2330:
2331: -- return the comp_posting_date
2332: cursor c_pay_proposal_date is
2333: select max(change_date)
2334: from per_pay_proposals ppp
2335: ,ben_cwb_person_rates rts
2336: where rts.pay_proposal_id = ppp.pay_proposal_id
2337: and rts.group_per_in_ler_id = p_group_per_in_ler_id
2338: and rts.group_pl_id = p_group_plan_id