APPS.HRDYNDBI dependencies on PAY_BALANCE_DIMENSIONS

Line 1274: l_dbi_function pay_balance_dimensions.database_item_function%type;

1270: --
1271: l_route_id ff_routes.route_id%type;
1272: l_db_item_name ff_database_items.user_name%type;
1273: l_dbitem_def_text ff_database_items.definition_text%type;
1274: l_dbi_function pay_balance_dimensions.database_item_function%type;
1275:
1276: startup_mode varchar2(10);
1277: rgeflg varchar2(1);
1278: usr_ent_id number;

Line 1371: from pay_balance_dimensions BALDIM,

1367: ' ','_'))
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

Line 1628: from pay_balance_dimensions BALDIM,

1624: select upper(replace(BALTYPE.balance_name ||
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

Line 1810: from pay_balance_dimensions BALDIM,

1806: select upper(replace(BALTYPE.balance_name ||
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

Line 8190: , pay_balance_dimensions d

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
8194: ;

Line 8381: from pay_balance_dimensions_tl bd

8377: (p_balance_dimension_id in number
8378: ,p_language in varchar2
8379: ) is
8380: select bd.database_item_suffix
8381: from pay_balance_dimensions_tl bd
8382: where bd.balance_dimension_id = p_balance_dimension_id
8383: and bd.language = p_language
8384: ;
8385: --

Line 8387: l_dbi_suffix pay_balance_dimensions_tl.database_item_suffix%type;

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
8391: open csr_balance_name