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_POST_PROCESS dependencies on BEN_CWB_PERSON_RATES

Line 288: FROM ben_cwb_person_rates rt

284:
285: CURSOR c_rate_ovn (v_group_per_in_ler_id IN NUMBER, v_pl_id IN NUMBER, v_oipl_id IN NUMBER)
286: IS
287: SELECT object_version_number
288: FROM ben_cwb_person_rates rt
289: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
290: AND rt.pl_id = v_pl_id
291: AND rt.oipl_id = v_oipl_id;
292:

Line 472: ben_cwb_person_rates

468: AND hrchy.lvl_num > 0)
469: )
470: and not exists(
471: select null from
472: ben_cwb_person_rates
473: where group_per_in_ler_id = pil.per_in_ler_id
474: )
475: and (v_business_group_id is null or
476: per.business_group_id = v_business_group_id)

Line 504: , ben_cwb_person_rates rates

500: , ben_per_in_ler mgr_pil
501: , ben_cwb_group_hrchy hrchy
502: , per_business_groups_perf bg
503: , ben_cwb_person_info per
504: , ben_cwb_person_rates rates
505: , ben_cwb_pl_dsgn dsgn
506: WHERE pil.per_in_ler_stat_cd = 'STRTD'
507: AND pil.group_pl_id = v_pl_id
508: AND pil.lf_evt_ocrd_dt = v_lf_evt_orcd_date

Line 541: from ben_cwb_person_rates

537:
538: CURSOR c_check_eligibility (v_group_per_in_ler_id IN NUMBER)
539: IS
540: select null
541: from ben_cwb_person_rates
542: where group_per_in_ler_id = v_group_per_in_ler_id
543: and oipl_id = -1
544: and elig_flag = 'Y';
545:

Line 633: FROM ben_cwb_person_rates rt

629:
630: CURSOR c_task_type (v_group_per_in_ler_id IN NUMBER)
631: IS
632: SELECT dsgn.ws_sub_acty_typ_cd
633: FROM ben_cwb_person_rates rt
634: , ben_cwb_pl_dsgn dsgn
635: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
636: AND rt.pl_id = dsgn.pl_id
637: AND rt.oipl_id = dsgn.oipl_id

Line 671: FROM ben_cwb_person_rates rt

667: ,v_effective_date in date
668: )
669: IS
670: SELECT SUM (rt.ws_val)
671: FROM ben_cwb_person_rates rt
672: ,ben_oipl_f oipl
673: ,ben_opt_f opt
674: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
675: AND rt.group_pl_id = v_group_pl_id

Line 693: FROM ben_cwb_person_rates rt

689: ) IS
690: SELECT DECODE(v_rule_based,'Y',
691: min(WS_RT_START_DATE),
692: min(OVRID_RT_STRT_DT)) effective_date
693: FROM ben_cwb_person_rates rt
694: , ben_oipl_f oipl
695: , ben_cwb_pl_dsgn dsgn
696: , ben_opt_f opt
697: , ben_cwb_person_info info

Line 741: FROM ben_cwb_person_rates rt

737: , rt.elig_sal_val
738: , xchg.xchg_rate
739: , rt.elig_flag
740: , rt.currency
741: FROM ben_cwb_person_rates rt
742: , ben_oipl_f oipl
743: , ben_cwb_pl_dsgn dsgn
744: , ben_opt_f opt
745: , ben_cwb_person_info info

Line 801: FROM ben_cwb_person_rates rt

797: , xchg.xchg_rate
798: , rt.elig_flag
799: , info.fte_factor
800: , rt.currency
801: FROM ben_cwb_person_rates rt
802: , ben_cwb_pl_dsgn dsgn
803: , ben_cwb_person_info info
804: , ben_per_in_ler pil
805: , ben_oipl_f oipl

Line 995: ,ben_cwb_person_rates r

991: AND info.group_per_in_ler_id = pil.per_in_ler_id
992: AND NOT EXISTS (
993: SELECT NULL
994: FROM ben_cwb_group_hrchy h, ben_per_in_ler p
995: ,ben_cwb_person_rates r
996: WHERE h.mgr_per_in_ler_id = pil.per_in_ler_id
997: AND h.lvl_num > 0
998: AND p.per_in_ler_id = h.emp_per_in_ler_id
999: AND p.lf_evt_ocrd_dt = pil.lf_evt_ocrd_dt

Line 1193: FROM ben_cwb_person_rates rates

1189: FROM ben_transaction trans,
1190: ben_cwb_pl_dsgn dsgn
1191: WHERE trans.transaction_id IN
1192: (SELECT DISTINCT pl_id
1193: FROM ben_cwb_person_rates rates
1194: WHERE group_per_in_ler_id = v_group_per_in_ler_id)
1195: AND trans.transaction_type = 'CWBPPOVDT' || to_char(v_lf_evt_ocrd_dt,'yyyy/mm/dd');
1196:
1197: CURSOR c_slaves(v_request_id IN NUMBER)

Line 1213: FROM BEN_CWB_PERSON_RATES

1209: v_group_oipl_id IN NUMBER,
1210: v_lf_evt_ocrd_dt IN DATE)
1211: IS
1212: SELECT WS_RT_START_DATE
1213: FROM BEN_CWB_PERSON_RATES
1214: WHERE GROUP_PER_IN_LER_ID = v_group_per_in_ler_id
1215: AND PL_ID = v_pl_id
1216: AND OIPL_ID = v_oipl_id
1217: AND LF_EVT_OCRD_DT = v_lf_evt_ocrd_dt

Line 2818: ben_cwb_person_rates_api.update_person_rate

2814: INTO l_rate_ovn;
2815:
2816: CLOSE c_rate_ovn;
2817: write_m ('Time before updating the person rates with proposal and element entry ids '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
2818: ben_cwb_person_rates_api.update_person_rate
2819: (p_group_per_in_ler_id => p_group_per_in_ler_id
2820: , p_pl_id => sal_rate_rec.pl_id
2821: , p_oipl_id => sal_rate_rec.oipl_id
2822: , p_pay_proposal_id => l_pay_proposal_id

Line 3181: ben_cwb_person_rates_api.update_person_rate

3177: INTO l_rate_ovn;
3178:
3179: CLOSE c_rate_ovn;
3180: write_m ('Time before updating person rates '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
3181: ben_cwb_person_rates_api.update_person_rate
3182: (p_group_per_in_ler_id => p_group_per_in_ler_id
3183: , p_pl_id => p_pl_id
3184: , p_oipl_id => p_oipl_id
3185: --, p_element_entry_value_id => l_ele_ent_id

Line 3297: ben_cwb_person_rates_api.update_person_rate

3293:
3294: CLOSE c_rate_ovn;
3295: BEGIN
3296: IF(NOT l_error) THEN
3297: ben_cwb_person_rates_api.update_person_rate
3298: (p_group_per_in_ler_id => p_group_per_in_ler_id
3299: , p_pl_id => p_pl_id
3300: , p_oipl_id => p_oipl_id
3301: , p_element_entry_value_id => p_element_entry_value_id

Line 3860: ben_cwb_person_rates_api.update_person_rate

3856: write_h ('||p_oipl_id ' || rt_rec.oipl_id);
3857: write_h ('||p_comp_posting_date ' || l_effective_date);
3858: write_h ('||p_object_version_number ' || rt_rec.object_version_number);
3859: write_h ('================================================================');
3860: ben_cwb_person_rates_api.update_person_rate
3861: (p_group_per_in_ler_id => p_group_per_in_ler_id
3862: , p_pl_id => rt_rec.pl_id
3863: , p_oipl_id => rt_rec.oipl_id
3864: , p_comp_posting_date => l_effective_date