APPS.HRDYNDBI dependencies on PAY_BALANCE_TYPES

Line 1262: from pay_balance_types

1258: --
1259: cursor get_cat_id(p_bal_type number)
1260: is
1261: select balance_category_id
1262: from pay_balance_types
1263: where balance_type_id = p_bal_type;
1264: --
1265: cursor get_sess_date
1266: is

Line 1281: l_bal_cat_id pay_balance_types.balance_category_id%type;

1277: rgeflg varchar2(1);
1278: usr_ent_id number;
1279: route_param_value number;
1280: l_flag_set number;
1281: l_bal_cat_id pay_balance_types.balance_category_id%type;
1282: l_run_bal_flag pay_defined_balances.save_run_balance%type;
1283: l_sess_date date;
1284: l_ora_db_vers number; -- db version number for LOW_VOLUME
1285:

Line 1372: pay_balance_types BALTYPE

1368: into l_route_id,
1369: l_dbi_function,
1370: l_db_item_name
1371: from pay_balance_dimensions BALDIM,
1372: pay_balance_types BALTYPE
1373: where BALDIM.balance_dimension_id = p_balance_dimension_id
1374: and BALTYPE.balance_type_id = p_balance_type_id;
1375: EXCEPTION WHEN OTHERS THEN
1376: hrrbdeib_trace_on;

Line 1629: pay_balance_types BALTYPE

1625: BALDIM.database_item_suffix,
1626: ' ','_'))
1627: into l_db_item_name
1628: from pay_balance_dimensions BALDIM,
1629: pay_balance_types BALTYPE
1630: where BALDIM.balance_dimension_id = c2rec.balance_dimension_id
1631: and BALTYPE.balance_type_id = c2rec.balance_type_id;
1632: EXCEPTION WHEN OTHERS THEN
1633: hrrbdeib_trace_on;

Line 1811: pay_balance_types BALTYPE

1807: BALDIM.database_item_suffix,
1808: ' ','_'))
1809: into l_db_item_name
1810: from pay_balance_dimensions BALDIM,
1811: pay_balance_types BALTYPE
1812: where BALDIM.balance_dimension_id = c2rec.balance_dimension_id
1813: and BALTYPE.balance_type_id = c2rec.balance_type_id;
1814: EXCEPTION WHEN OTHERS THEN
1815: hrrbdeib_trace_on;

Line 8189: , pay_balance_types b

8185: , db.business_group_id
8186: , db.balance_type_id
8187: , db.balance_dimension_id
8188: from pay_defined_balances db
8189: , pay_balance_types b
8190: , pay_balance_dimensions d
8191: where db.defined_balance_id = p_defined_balance_id
8192: and b.balance_type_id = db.balance_type_id
8193: and d.balance_dimension_id = db.balance_dimension_id

Line 8372: from pay_balance_types_tl b

8368: (p_balance_type_id in number
8369: ,p_language in varchar2
8370: ) is
8371: select b.balance_name
8372: from pay_balance_types_tl b
8373: where b.balance_type_id = p_balance_type_id
8374: and b.language = p_language
8375: ;
8376: cursor csr_dbi_suffix

Line 8386: l_balance_name pay_balance_types_tl.balance_name%type;

8382: where bd.balance_dimension_id = p_balance_dimension_id
8383: and bd.language = p_language
8384: ;
8385: --
8386: l_balance_name pay_balance_types_tl.balance_name%type;
8387: l_dbi_suffix pay_balance_dimensions_tl.database_item_suffix%type;
8388: l_debug boolean := hr_utility.debug_enabled;
8389: l_found boolean;
8390: begin