APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PAY_DIMENSION_ROUTES

Line 527: l_balance_type_column pay_dimension_routes.balance_type_column%type;

523: p_frequency in number,
524: p_exclude_reversal in boolean)
525: is
526: l_route_id number;
527: l_balance_type_column pay_dimension_routes.balance_type_column%type;
528: l_run_dimension_id number;
529: begin
530: if p_route_type = 'SRB' and p_date_type = 'DE' then
531: fnd_message.set_name('PAY', 'PAY_JP_DIM_DE_SRB_NOT_SUPPORT');

Line 554: insert into pay_dimension_routes(

550: where dimension_name = '_ASG_RUN'
551: and legislation_code = 'JP';
552: end if;
553: --
554: insert into pay_dimension_routes(
555: BALANCE_DIMENSION_ID,
556: PRIORITY,
557: ROUTE_TYPE,
558: ROUTE_ID,

Line 908: from pay_dimension_routes

904: delete_latest_balances(l_defined_balance_ids(i));
905: end loop;
906: --
907: delete
908: from pay_dimension_routes
909: where balance_dimension_id = p_balance_dimension_id;
910: --
911: upload_balance_dimension(
912: p_balance_dimension_id => l_balance_dimension_id,

Line 1171: -- Delete PAY_DIMENSION_ROUTES

1167: for l_rec in csr_def loop
1168: delete_dbi(l_rec.defined_balance_id, l_rec.business_group_id);
1169: end loop;
1170: --
1171: -- Delete PAY_DIMENSION_ROUTES
1172: --
1173: for l_rec in csr_dim loop
1174: delete
1175: from pay_dimension_routes

Line 1175: from pay_dimension_routes

1171: -- Delete PAY_DIMENSION_ROUTES
1172: --
1173: for l_rec in csr_dim loop
1174: delete
1175: from pay_dimension_routes
1176: where balance_dimension_id = l_rec.balance_dimension_id;
1177: end loop;
1178: --
1179: -- Delete FF_ROUTES