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_COBRA_REQUIREMENTS dependencies on BEN_ACTY_BASE_RT_F

Line 3216: from ben_acty_base_rt_f abr

3212: abr.rt_mlt_cd,
3213: abr.parnt_chld_cd,
3214: abr.rcrrg_cd,
3215: abr.name
3216: from ben_acty_base_rt_f abr
3217: where abr.acty_base_rt_id=c_acty_base_rt_id
3218: and c_effective_date between abr.effective_start_date
3219: and abr.effective_end_date;
3220:

Line 3229: from ben_acty_base_rt_f abr,

3225: )
3226: is
3227: select abr2.rt_mlt_cd,
3228: abr2.entr_ann_val_flag
3229: from ben_acty_base_rt_f abr,
3230: ben_acty_base_rt_f abr2
3231: where abr.acty_base_rt_id = c_acty_base_rt_id
3232: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
3233: and abr2.parnt_chld_cd = 'PARNT'

Line 3230: ben_acty_base_rt_f abr2

3226: is
3227: select abr2.rt_mlt_cd,
3228: abr2.entr_ann_val_flag
3229: from ben_acty_base_rt_f abr,
3230: ben_acty_base_rt_f abr2
3231: where abr.acty_base_rt_id = c_acty_base_rt_id
3232: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
3233: and abr2.parnt_chld_cd = 'PARNT'
3234: and c_effective_date

Line 3569: ,ben_acty_base_rt_f i

3565: ,pay_element_types_f b
3566: ,pay_assignment_actions d
3567: ,pay_payroll_actions e
3568: ,pay_run_results h
3569: ,ben_acty_base_rt_f i
3570: ,pay_input_values_f j
3571: WHERE d.assignment_id = c_assignment_id
3572: AND d.payroll_action_id = e.payroll_action_id
3573: AND i.input_value_id = j.input_value_id

Line 3749: ,ben_acty_base_rt_f abr

3745: ,pen.prtt_enrt_rslt_id
3746: ,prv.mlt_cd
3747: FROM ben_prtt_enrt_rslt_f pen
3748: ,ben_prtt_rt_val prv
3749: ,ben_acty_base_rt_f abr
3750: WHERE pen.person_id = c_person_id
3751: AND pen.pgm_id = c_pgm_id
3752: AND pen.pl_typ_id = c_pl_typ_id
3753: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 3789: ,ben_acty_base_rt_f abr

3785: ,prv.mlt_cd
3786: ,abr.name
3787: FROM ben_prtt_enrt_rslt_f pen
3788: ,ben_prtt_rt_val prv
3789: ,ben_acty_base_rt_f abr
3790: WHERE pen.person_id = c_person_id
3791: AND pen.pgm_id = c_pgm_id
3792: AND pen.pl_typ_id = c_pl_typ_id
3793: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 3999: from ben_acty_base_rt_f abr,

3995: ,c_business_group_id in number
3996: ,c_effective_date in date
3997: ) is
3998: select entries.balance_adj_cost_flag
3999: from ben_acty_base_rt_f abr,
4000: pay_element_entry_values_f ee_values,
4001: pay_element_entries_f entries
4002: where abr.acty_base_rt_id = c_acty_base_rt_id
4003: and c_effective_date between abr.effective_start_date

Line 4021: from ben_acty_base_rt_f abr,

4017: ) is
4018: select elk.costable_type,
4019: link_inp_val.element_link_id,
4020: abr.input_value_id
4021: from ben_acty_base_rt_f abr,
4022: pay_input_values_f inp_val,
4023: pay_element_links_f elk,
4024: pay_link_input_values_f link_inp_val
4025: where acty_base_rt_id = c_acty_base_rt_id

Line 4110: ,ben_acty_base_rt_f abr

4106: ,abr.element_type_id
4107: ,abr.input_value_id
4108: FROM ben_prtt_enrt_rslt_f pen
4109: ,ben_prtt_rt_val prv
4110: ,ben_acty_base_rt_f abr
4111: WHERE pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
4112: AND c_effective_date BETWEEN pen.enrt_cvg_strt_dt
4113: AND pen.enrt_cvg_thru_dt
4114: AND pen.enrt_cvg_thru_dt <= pen.effective_end_date

Line 4146: ,ben_acty_base_rt_f i

4142: ,pay_element_types_f b
4143: ,pay_assignment_actions d
4144: ,pay_payroll_actions e
4145: ,pay_run_results h
4146: ,ben_acty_base_rt_f i
4147: ,pay_input_values_f j
4148: WHERE d.assignment_id = c_assignment_id
4149: AND d.payroll_action_id = e.payroll_action_id
4150: AND i.input_value_id = j.input_value_id

Line 4181: ,ben_acty_base_rt_f i

4177: ,pay_element_types_f b
4178: ,pay_assignment_actions d
4179: ,pay_payroll_actions e
4180: ,pay_run_results h
4181: ,ben_acty_base_rt_f i
4182: ,pay_input_values_f j
4183: WHERE d.assignment_id = c_assignment_id
4184: AND d.payroll_action_id = e.payroll_action_id
4185: AND i.input_value_id = j.input_value_id

Line 4219: ,ben_acty_base_rt_f i

4215: ,pay_element_types_f b
4216: ,pay_assignment_actions d
4217: ,pay_payroll_actions e
4218: ,pay_run_results h
4219: ,ben_acty_base_rt_f i
4220: ,pay_input_values_f j
4221: WHERE d.assignment_id = c_assignment_id
4222: AND d.payroll_action_id = e.payroll_action_id
4223: AND i.input_value_id = j.input_value_id

Line 4261: ,ben_acty_base_rt_f abr

4257: ,pen.prtt_enrt_rslt_id
4258: ,prv.mlt_cd
4259: FROM ben_prtt_enrt_rslt_f pen
4260: ,ben_prtt_rt_val prv
4261: ,ben_acty_base_rt_f abr
4262: WHERE pen.person_id = c_person_id
4263: AND pen.pgm_id = c_pgm_id
4264: AND pen.pl_typ_id = c_pl_typ_id
4265: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 4297: ,ben_acty_base_rt_f abr

4293: ,pen.prtt_enrt_rslt_id
4294: ,prv.mlt_cd
4295: FROM ben_prtt_enrt_rslt_f pen
4296: ,ben_prtt_rt_val prv
4297: ,ben_acty_base_rt_f abr
4298: WHERE pen.person_id = c_person_id
4299: AND pen.pgm_id = c_pgm_id
4300: AND pen.pl_typ_id = c_pl_typ_id
4301: AND pen.prtt_enrt_rslt_stat_cd IS NULL