APPS.HRDYNDBI dependencies on PAY_BALANCE_DIMENSIONS

Line 1277: l_dbi_function pay_balance_dimensions.database_item_function%type;

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

Line 1374: from pay_balance_dimensions BALDIM,

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

Line 1631: from pay_balance_dimensions BALDIM,

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

Line 1813: from pay_balance_dimensions BALDIM,

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

Line 8267: , pay_balance_dimensions d

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

Line 8458: from pay_balance_dimensions_tl bd

8454: (p_balance_dimension_id in number
8455: ,p_language in varchar2
8456: ) is
8457: select bd.database_item_suffix
8458: from pay_balance_dimensions_tl bd
8459: where bd.balance_dimension_id = p_balance_dimension_id
8460: and bd.language = p_language
8461: ;
8462: --

Line 8464: l_dbi_suffix pay_balance_dimensions_tl.database_item_suffix%type;

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