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.PAY_DB_PAY_SETUP dependencies on PAY_BALANCE_TYPES

Line 1527: from pay_balance_types

1523: ,p_ctl_leg varchar2)
1524: is
1525: select balance_type_id
1526: , base_balance_type_id
1527: from pay_balance_types
1528: where balance_name = p_base_bal_name
1529: and nvl(business_group_id, nvl(p_ctl_bg, -1)) = nvl(p_ctl_bg, -1)
1530: and nvl(legislation_code, nvl(p_ctl_leg, ' ')) = nvl(p_ctl_leg, ' ');
1531: --

Line 1578: l_bt_id pay_balance_types.balance_type_id%type;

1574: l_cat_bg pay_balance_categories_f.business_group_id%type;
1575: v_legislation_code varchar2(30);
1576: l_ctl_bg number;
1577: l_ctl_leg varchar2(30);
1578: l_bt_id pay_balance_types.balance_type_id%type;
1579: l_bbt_id pay_balance_types.base_balance_type_id%type;
1580: l_prim_iv pay_balance_types.input_value_id%type;
1581: l_prim_ele pay_element_types_f.element_type_id%type;
1582: l_mode varchar2(30);

Line 1579: l_bbt_id pay_balance_types.base_balance_type_id%type;

1575: v_legislation_code varchar2(30);
1576: l_ctl_bg number;
1577: l_ctl_leg varchar2(30);
1578: l_bt_id pay_balance_types.balance_type_id%type;
1579: l_bbt_id pay_balance_types.base_balance_type_id%type;
1580: l_prim_iv pay_balance_types.input_value_id%type;
1581: l_prim_ele pay_element_types_f.element_type_id%type;
1582: l_mode varchar2(30);
1583: --

Line 1580: l_prim_iv pay_balance_types.input_value_id%type;

1576: l_ctl_bg number;
1577: l_ctl_leg varchar2(30);
1578: l_bt_id pay_balance_types.balance_type_id%type;
1579: l_bbt_id pay_balance_types.base_balance_type_id%type;
1580: l_prim_iv pay_balance_types.input_value_id%type;
1581: l_prim_ele pay_element_types_f.element_type_id%type;
1582: l_mode varchar2(30);
1583: --
1584: begin

Line 1811: pay_balance_types_pkg.insert_row(

1807: end if;
1808: --
1809: -- Create balance
1810: --
1811: pay_balance_types_pkg.insert_row(
1812: X_ROWID =>v_rowid,
1813: X_BALANCE_TYPE_ID =>v_balance_type_id,
1814: X_BUSINESS_GROUP_ID =>v_business_group_id,
1815: X_LEGISLATION_CODE =>p_legislation_code,

Line 1980: from pay_balance_types bt

1976: select bt.balance_type_id,
1977: bt.legislation_subgroup
1978: into v_balance_type_id,
1979: v_legislation_subgroup
1980: from pay_balance_types bt
1981: where upper(bt.balance_name) = upper(p_balance_name)
1982: and nvl(bt.business_group_id,nvl(v_business_group_id,-1))
1983: = nvl(v_business_group_id,-1)
1984: and nvl(bt.legislation_code,nvl(p_legislation_code,'-1'))

Line 2079: from pay_balance_types

2075: ,p_leg_code varchar2
2076: )
2077: is
2078: select balance_category_id
2079: from pay_balance_types
2080: where balance_name = p_bal_type
2081: and nvl(legislation_code,'NULL') = nvl(p_leg_code, 'NULL')
2082: and nvl(business_group_id, -1) = nvl(p_bg_id, -1);
2083: --

Line 2205: from pay_balance_types bt

2201: , v_bt_legislation_code
2202: , v_bt_balance_type_id
2203: , v_bt_legislation_subgroup
2204: , v_bt_balance_category_id
2205: from pay_balance_types bt
2206: where upper(bt.balance_name) = upper(p_balance_name)
2207: and nvl(bt.business_group_id,nvl(v_business_group_id,-1))
2208: = nvl(v_business_group_id,-1)
2209: and nvl(bt.legislation_code,nvl(v_legislation_code,'-1'))