APPS.HR_GBBAL dependencies on PAY_BALANCE_DIMENSIONS

Line 318: pay_balance_dimensions pbd

314: cursor relevant(c_balance_type_id IN NUMBER,
315: c_db_item_suffix IN VARCHAR2) IS
316: select pdb.defined_balance_id from
317: pay_defined_balances pdb,
318: pay_balance_dimensions pbd
319: where pdb.balance_dimension_id = pbd.balance_dimension_id
320: and pbd.database_item_suffix = c_db_item_suffix
321: and pdb.balance_type_id = c_balance_type_id;
322: --

Line 647: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

643: l_regular_payment_date DATE;
644: l_action_sequence NUMBER;
645: l_business_group_id NUMBER;
646: l_dimension_bgid NUMBER;
647: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
648: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;
649: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;
650: l_latest_value_exists VARCHAR(2);
651: l_period_end_date DATE;

Line 648: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;

644: l_action_sequence NUMBER;
645: l_business_group_id NUMBER;
646: l_dimension_bgid NUMBER;
647: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
648: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;
649: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;
650: l_latest_value_exists VARCHAR(2);
651: l_period_end_date DATE;
652: l_date_paid DATE;

Line 649: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;

645: l_business_group_id NUMBER;
646: l_dimension_bgid NUMBER;
647: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
648: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;
649: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;
650: l_latest_value_exists VARCHAR(2);
651: l_period_end_date DATE;
652: l_date_paid DATE;
653: --

Line 686: pay_balance_dimensions DIM

682: DIM.legislation_code,
683: DIM.business_group_id
684: FROM
685: pay_defined_balances DB,
686: pay_balance_dimensions DIM
687: WHERE DB.defined_balance_id = p_defined_balance_id
688: AND DIM.balance_dimension_id = DB.balance_dimension_id;
689: --
690: BEGIN

Line 1019: from pay_balance_dimensions pbd,

1015: --
1016: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
1017: select pdb.balance_type_id,
1018: pbd.dimension_name
1019: from pay_balance_dimensions pbd,
1020: pay_defined_balances pdb
1021: where pdb.defined_balance_id = c_defined_balance_id
1022: and pdb.balance_dimension_id = pbd.balance_dimension_id;
1023: --

Line 1122: from pay_balance_dimensions pbd,

1118: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
1119: select pdb.balance_type_id,
1120: pbd.dimension_name,
1121: pbd.route_id
1122: from pay_balance_dimensions pbd,
1123: pay_defined_balances pdb
1124: where pdb.defined_balance_id = c_defined_balance_id
1125: and pdb.balance_dimension_id = pbd.balance_dimension_id;
1126: --

Line 1138: pay_balance_dimensions pbd

1134: ffc.context_name
1135: from pay_action_contexts pca,
1136: ff_contexts ffc,
1137: ff_route_context_usages frc,
1138: pay_balance_dimensions pbd
1139: where pbd.route_id = p_route_id
1140: and pbd.route_id = frc.route_id
1141: and frc.context_id = ffc.context_id
1142: and ffc.context_id = pca.context_id

Line 3248: pay_balance_dimensions_s.NEXTVAL

3244: l_route_text ff_routes.text%TYPE;
3245: l_bal_next number;
3246: BEGIN
3247: SELECT
3248: pay_balance_dimensions_s.NEXTVAL
3249: INTO
3250: l_bal_next
3251: FROM DUAL;
3252:

Line 3378: INSERT INTO pay_balance_dimensions

3374: -- Find the current request id
3375: l_req_id := fnd_profile.value('CONC_REQUEST_ID');
3376:
3377: -- insert into the table
3378: INSERT INTO pay_balance_dimensions
3379: (
3380: balance_dimension_id,
3381: business_group_id,
3382: legislation_code,

Line 3397: pay_balance_dimensions_s.CURRVAL,

3393: feed_checking_type
3394: )
3395: VALUES
3396: (
3397: pay_balance_dimensions_s.CURRVAL,
3398: p_business_group_id,
3399: NULL,
3400: ff_routes_s.CURRVAL,
3401: p_suffix,

Line 3871: from pay_balance_dimensions

3867: --
3868: if g_asg_td_ytd is null then
3869: select balance_dimension_id
3870: into g_asg_td_ytd
3871: from pay_balance_dimensions
3872: where dimension_name = '_ASG_TD_YTD';
3873: end if;
3874: --
3875: -- Check to see whether there are any latest balances for the