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.

[Home] [Help]

APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_BKDT_DEFAULTS_ALL

Line 1679: pn_var_bkdt_defaults_all dd

1675:
1676: CURSOR rent_no_c1(p_vr_ID IN NUMBER) IS /* 9609370 */
1677: select distinct v.var_rent_id
1678: from pn_var_rents_all v, pn_var_bkhd_defaults_all hd,
1679: pn_var_bkdt_defaults_all dd
1680: WHERE V.VAR_RENT_ID = HD.VAR_RENT_ID
1681: and v.var_rent_id = p_vr_ID
1682: and hd.bkhd_default_id = dd.bkhd_default_id
1683: and hd.breakpoint_type = 'STRATIFIED'

Line 1685: from pn_var_bkdt_defaults_all dd2

1681: and v.var_rent_id = p_vr_ID
1682: and hd.bkhd_default_id = dd.bkhd_default_id
1683: and hd.breakpoint_type = 'STRATIFIED'
1684: and exists (select 'Y'
1685: from pn_var_bkdt_defaults_all dd2
1686: where dd2.bkhd_default_id = dd.bkhd_default_id
1687: and dd2.bkdt_default_id <> dd.bkdt_default_id
1688: and dd2.bkpt_rate = dd.bkpt_rate
1689: AND DD2.BKDT_START_DATE = DD.BKDT_START_DATE