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 3264: pay_balance_dimensions_s.NEXTVAL

3260: l_route_text ff_routes.text%TYPE;
3261: l_bal_next number;
3262: BEGIN
3263: SELECT
3264: pay_balance_dimensions_s.NEXTVAL
3265: INTO
3266: l_bal_next
3267: FROM DUAL;
3268:

Line 3394: INSERT INTO pay_balance_dimensions

3390: -- Find the current request id
3391: l_req_id := fnd_profile.value('CONC_REQUEST_ID');
3392:
3393: -- insert into the table
3394: INSERT INTO pay_balance_dimensions
3395: (
3396: balance_dimension_id,
3397: business_group_id,
3398: legislation_code,

Line 3413: pay_balance_dimensions_s.CURRVAL,

3409: feed_checking_type
3410: )
3411: VALUES
3412: (
3413: pay_balance_dimensions_s.CURRVAL,
3414: p_business_group_id,
3415: NULL,
3416: ff_routes_s.CURRVAL,
3417: p_suffix,

Line 3954: from pay_balance_dimensions

3950: --
3951: if g_asg_td_ytd is null then
3952: select balance_dimension_id
3953: into g_asg_td_ytd
3954: from pay_balance_dimensions
3955: where dimension_name = '_ASG_TD_YTD';
3956: end if;
3957: --
3958: -- Check to see whether there are any latest balances for the