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_FR_DB_PAY_SETUP dependencies on PAY_BALANCE_TYPES

Line 1525: from pay_balance_types

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

Line 1576: l_bt_id pay_balance_types.balance_type_id%type;

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

Line 1577: l_bbt_id pay_balance_types.base_balance_type_id%type;

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

Line 1578: l_prim_iv pay_balance_types.input_value_id%type;

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

Line 1809: pay_balance_types_pkg.insert_row(

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

Line 1979: from pay_balance_types bt

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

Line 2086: from pay_balance_types

2082: ,p_leg_code varchar2
2083: )
2084: is
2085: select balance_category_id
2086: from pay_balance_types
2087: where balance_name = p_bal_type
2088: and nvl(legislation_code,'NULL') = nvl(p_leg_code, 'NULL')
2089: and nvl(business_group_id, -1) = nvl(p_bg_id, -1);
2090: --

Line 2212: from pay_balance_types bt

2208: , v_bt_legislation_code
2209: , v_bt_balance_type_id
2210: , v_bt_legislation_subgroup
2211: , v_bt_balance_category_id
2212: from pay_balance_types bt
2213: where upper(bt.balance_name) = upper(p_balance_name)
2214: and nvl(bt.business_group_id,nvl(v_business_group_id,-1))
2215: = nvl(v_business_group_id,-1)
2216: and nvl(bt.legislation_code,nvl(v_legislation_code,'-1'))