APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 771: l_temp_val pay_balance_dimensions.dimension_name%type;

767: --------------------------------------------------------------------------------
768: function DBCDimName_is_found
769: (p_bindex IN NUMBER)
770: return BOOLEAN is
771: l_temp_val pay_balance_dimensions.dimension_name%type;
772: begin
773: begin
774: l_temp_val := DBCDimName(p_bindex);
775: exception

Line 1182: l_dimension_type pay_balance_dimensions.dimension_type%type;

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

Line 1183: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;

1179: l_run_route_bool boolean;
1180: l_temp_num number;
1181: --
1182: l_dimension_type pay_balance_dimensions.dimension_type%type;
1183: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1184: l_dimension_name pay_balance_dimensions.dimension_name%type;
1185: l_balance_type_id pay_defined_balances.balance_type_id%type;
1186: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;
1187: l_leg_code pay_balance_dimensions.legislation_code%type;

Line 1184: l_dimension_name pay_balance_dimensions.dimension_name%type;

1180: l_temp_num number;
1181: --
1182: l_dimension_type pay_balance_dimensions.dimension_type%type;
1183: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1184: l_dimension_name pay_balance_dimensions.dimension_name%type;
1185: l_balance_type_id pay_defined_balances.balance_type_id%type;
1186: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;
1187: l_leg_code pay_balance_dimensions.legislation_code%type;
1188:

Line 1187: l_leg_code pay_balance_dimensions.legislation_code%type;

1183: l_dbi_suffix pay_balance_dimensions.database_item_suffix%type;
1184: l_dimension_name pay_balance_dimensions.dimension_name%type;
1185: l_balance_type_id pay_defined_balances.balance_type_id%type;
1186: l_jurisdiction_level pay_balance_types.jurisdiction_level%type;
1187: l_leg_code pay_balance_dimensions.legislation_code%type;
1188:
1189: CURSOR csr_context_exists IS
1190: SELECT 1
1191: FROM ff_contexts cxt

Line 1249: pay_balance_dimensions pbd

1245: begin
1246: select pbd.legislation_code
1247: into l_leg_code
1248: from pay_defined_balances pdb,
1249: pay_balance_dimensions pbd
1250: where pdb.defined_balance_id = p_defined_balance_id
1251: and pbd.balance_dimension_id = pdb.balance_dimension_id;
1252: exception
1253: when no_data_found then

Line 1286: pay_balance_dimensions pbd,

1282: l_dimension_name,
1283: l_jurisdiction_level,
1284: l_leg_code
1285: from pay_defined_balances pdb,
1286: pay_balance_dimensions pbd,
1287: pay_balance_types pbt
1288: where pdb.defined_balance_id = p_defined_balance_id
1289: and pbd.balance_dimension_id = pdb.balance_dimension_id
1290: and pbt.balance_type_id = pdb.balance_type_id;