APPS.HRDYNDBI dependencies on PAY_BALANCE_TYPES

Line 1265: from pay_balance_types

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

Line 1284: l_bal_cat_id pay_balance_types.balance_category_id%type;

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

Line 1375: pay_balance_types BALTYPE

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

Line 1632: pay_balance_types BALTYPE

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

Line 1814: pay_balance_types BALTYPE

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

Line 8266: , pay_balance_types b

8262: , db.business_group_id
8263: , db.balance_type_id
8264: , db.balance_dimension_id
8265: from pay_defined_balances db
8266: , pay_balance_types b
8267: , pay_balance_dimensions d
8268: where db.defined_balance_id = p_defined_balance_id
8269: and b.balance_type_id = db.balance_type_id
8270: and d.balance_dimension_id = db.balance_dimension_id

Line 8449: from pay_balance_types_tl b

8445: (p_balance_type_id in number
8446: ,p_language in varchar2
8447: ) is
8448: select b.balance_name
8449: from pay_balance_types_tl b
8450: where b.balance_type_id = p_balance_type_id
8451: and b.language = p_language
8452: ;
8453: cursor csr_dbi_suffix

Line 8463: l_balance_name pay_balance_types_tl.balance_name%type;

8459: where bd.balance_dimension_id = p_balance_dimension_id
8460: and bd.language = p_language
8461: ;
8462: --
8463: l_balance_name pay_balance_types_tl.balance_name%type;
8464: l_dbi_suffix pay_balance_dimensions_tl.database_item_suffix%type;
8465: l_debug boolean := hr_utility.debug_enabled;
8466: l_found boolean;
8467: begin