APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 767: l_temp_val pay_balance_dimensions.dimension_name%type;

763: --------------------------------------------------------------------------------
764: function DBCDimName_is_found
765: (p_bindex IN NUMBER)
766: return BOOLEAN is
767: l_temp_val pay_balance_dimensions.dimension_name%type;
768: begin
769: begin
770: l_temp_val := DBCDimName(p_bindex);
771: exception

Line 1178: l_dimension_type pay_balance_dimensions.dimension_type%type;

1174: l_run_route varchar2(5);
1175: l_run_route_bool boolean;
1176: l_temp_num number;
1177: --
1178: l_dimension_type pay_balance_dimensions.dimension_type%type;
1179: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1180: l_dimension_name pay_balance_dimensions.dimension_name%type;
1181: l_balance_type_id pay_defined_balances.balance_type_id%type;
1182: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;

Line 1179: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;

1175: l_run_route_bool boolean;
1176: l_temp_num number;
1177: --
1178: l_dimension_type pay_balance_dimensions.dimension_type%type;
1179: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1180: l_dimension_name pay_balance_dimensions.dimension_name%type;
1181: l_balance_type_id pay_defined_balances.balance_type_id%type;
1182: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;
1183: l_leg_code pay_balance_dimensions.legislation_code%type;

Line 1180: l_dimension_name pay_balance_dimensions.dimension_name%type;

1176: l_temp_num number;
1177: --
1178: l_dimension_type pay_balance_dimensions.dimension_type%type;
1179: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1180: l_dimension_name pay_balance_dimensions.dimension_name%type;
1181: l_balance_type_id pay_defined_balances.balance_type_id%type;
1182: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;
1183: l_leg_code pay_balance_dimensions.legislation_code%type;
1184:

Line 1183: l_leg_code pay_balance_dimensions.legislation_code%type;

1179: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1180: l_dimension_name pay_balance_dimensions.dimension_name%type;
1181: l_balance_type_id pay_defined_balances.balance_type_id%type;
1182: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;
1183: l_leg_code pay_balance_dimensions.legislation_code%type;
1184:
1185: CURSOR csr_context_exists IS
1186: SELECT 1
1187: FROM ff_contexts cxt

Line 1245: pay_balance_dimensions pbd

1241: begin
1242: select pbd.legislation_code
1243: into l_leg_code
1244: from pay_defined_balances pdb,
1245: pay_balance_dimensions pbd
1246: where pdb.defined_balance_id = p_defined_balance_id
1247: and pbd.balance_dimension_id = pdb.balance_dimension_id;
1248: exception
1249: when no_data_found then

Line 1282: pay_balance_dimensions pbd,

1278: l_dimension_name,
1279: l_jurisdiction_level,
1280: l_leg_code
1281: from pay_defined_balances pdb,
1282: pay_balance_dimensions pbd,
1283: pay_balance_types pbt
1284: where pdb.defined_balance_id = p_defined_balance_id
1285: and pbd.balance_dimension_id = pdb.balance_dimension_id
1286: and pbt.balance_type_id = pdb.balance_type_id;