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 1550: from pay_balance_types

1546: ,p_ctl_leg varchar2)
1547: is
1548: select balance_type_id
1549: , base_balance_type_id
1550: from pay_balance_types
1551: where balance_name = p_base_bal_name
1552: and nvl(business_group_id, nvl(p_ctl_bg, -1)) = nvl(p_ctl_bg, -1)
1553: and nvl(legislation_code, nvl(p_ctl_leg, ' ')) = nvl(p_ctl_leg, ' ');
1554: --

Line 1601: l_bt_id pay_balance_types.balance_type_id%type;

1597: l_cat_bg pay_balance_categories_f.business_group_id%type;
1598: v_legislation_code varchar2(30);
1599: l_ctl_bg number;
1600: l_ctl_leg varchar2(30);
1601: l_bt_id pay_balance_types.balance_type_id%type;
1602: l_bbt_id pay_balance_types.base_balance_type_id%type;
1603: l_prim_iv pay_balance_types.input_value_id%type;
1604: l_prim_ele pay_element_types_f.element_type_id%type;
1605: l_mode varchar2(30);

Line 1602: l_bbt_id pay_balance_types.base_balance_type_id%type;

1598: v_legislation_code varchar2(30);
1599: l_ctl_bg number;
1600: l_ctl_leg varchar2(30);
1601: l_bt_id pay_balance_types.balance_type_id%type;
1602: l_bbt_id pay_balance_types.base_balance_type_id%type;
1603: l_prim_iv pay_balance_types.input_value_id%type;
1604: l_prim_ele pay_element_types_f.element_type_id%type;
1605: l_mode varchar2(30);
1606: --

Line 1603: l_prim_iv pay_balance_types.input_value_id%type;

1599: l_ctl_bg number;
1600: l_ctl_leg varchar2(30);
1601: l_bt_id pay_balance_types.balance_type_id%type;
1602: l_bbt_id pay_balance_types.base_balance_type_id%type;
1603: l_prim_iv pay_balance_types.input_value_id%type;
1604: l_prim_ele pay_element_types_f.element_type_id%type;
1605: l_mode varchar2(30);
1606: --
1607: begin

Line 1834: pay_balance_types_pkg.insert_row(

1830: end if;
1831: --
1832: -- Create balance
1833: --
1834: pay_balance_types_pkg.insert_row(
1835: X_ROWID =>v_rowid,
1836: X_BALANCE_TYPE_ID =>v_balance_type_id,
1837: X_BUSINESS_GROUP_ID =>v_business_group_id,
1838: X_LEGISLATION_CODE =>p_legislation_code,

Line 2003: from pay_balance_types bt

1999: select bt.balance_type_id,
2000: bt.legislation_subgroup
2001: into v_balance_type_id,
2002: v_legislation_subgroup
2003: from pay_balance_types bt
2004: where upper(bt.balance_name) = upper(p_balance_name)
2005: and nvl(bt.business_group_id,nvl(v_business_group_id,-1))
2006: = nvl(v_business_group_id,-1)
2007: and nvl(bt.legislation_code,nvl(p_legislation_code,'-1'))

Line 2102: from pay_balance_types

2098: ,p_leg_code varchar2
2099: )
2100: is
2101: select balance_category_id
2102: from pay_balance_types
2103: where balance_name = p_bal_type
2104: and nvl(legislation_code,'NULL') = nvl(p_leg_code, 'NULL')
2105: and nvl(business_group_id, -1) = nvl(p_bg_id, -1);
2106: --

Line 2228: from pay_balance_types bt

2224: , v_bt_legislation_code
2225: , v_bt_balance_type_id
2226: , v_bt_legislation_subgroup
2227: , v_bt_balance_category_id
2228: from pay_balance_types bt
2229: where upper(bt.balance_name) = upper(p_balance_name)
2230: and nvl(bt.business_group_id,nvl(v_business_group_id,-1))
2231: = nvl(v_business_group_id,-1)
2232: and nvl(bt.legislation_code,nvl(v_legislation_code,'-1'))