APPS.BEN_RECN_REP dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 475: ,pay_element_entry_values_f env

471: from ben_prtt_rt_val
472: where prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id) lf_rate ,
473: ( select sum(screen_entry_value)
474: from ben_prtt_rt_val prv
475: ,pay_element_entry_values_f env
476: where prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
477: and env.element_entry_value_id = prv.element_entry_value_id) lf_elem_val */
478: from ben_prtt_enrt_rslt_f pen,
479: ben_per_in_ler pil,

Line 1553: pay_element_entry_values_f env

1549: --
1550: cursor c_total_elem_entry(c_prtt_enrt_rslt_id number) is
1551: select sum(screen_entry_value)
1552: from ben_prtt_rt_val prv,
1553: pay_element_entry_values_f env
1554: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1555: and env.element_entry_value_id = prv.element_entry_value_id
1556: and tx_typ_cd in ('PRETAX' , 'AFTERTAX' , 'NOTAPPLICABLE' )
1557: and acty_typ_cd in ('EEPYC','ERC' , 'ERPYC')

Line 1640: pay_element_entry_values_f env

1636: --
1637: cursor c_element_val is
1638: select sum(env.screen_entry_value)
1639: from ben_prtt_rt_val prv,
1640: pay_element_entry_values_f env
1641: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1642: and (p_tx_typ_cd is null or prv.tx_typ_cd = p_tx_typ_cd)
1643: and prv.acty_typ_cd = p_acty_typ_cd
1644: and prv.prtt_rt_val_stat_cd is null

Line 1657: pay_element_entry_values_f env

1653: --
1654: cursor c_er_element_val is
1655: select sum(env.screen_entry_value)
1656: from ben_prtt_rt_val prv,
1657: pay_element_entry_values_f env
1658: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1659: and (p_tx_typ_cd is null or prv.tx_typ_cd = p_tx_typ_cd)
1660: and prv.acty_typ_cd in ('ERC' , 'ERPYC' )
1661: and prv.prtt_rt_val_stat_cd is null