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 917: from pay_dimension_routes

913: delete_latest_balances(l_defined_balance_ids(i));
914: end loop;
915: --
916: delete
917: from pay_dimension_routes
918: where balance_dimension_id = p_balance_dimension_id;
919: --
920: upload_balance_dimension(
921: p_balance_dimension_id => l_balance_dimension_id,

Line 1189: -- Delete PAY_DIMENSION_ROUTES

1185: for l_rec in csr_def loop
1186: delete_dbi(l_rec.defined_balance_id, l_rec.business_group_id);
1187: end loop;
1188: --
1189: -- Delete PAY_DIMENSION_ROUTES
1190: --
1191: for l_rec in csr_dim loop
1192: delete
1193: from pay_dimension_routes

Line 1193: from pay_dimension_routes

1189: -- Delete PAY_DIMENSION_ROUTES
1190: --
1191: for l_rec in csr_dim loop
1192: delete
1193: from pay_dimension_routes
1194: where balance_dimension_id = l_rec.balance_dimension_id;
1195: end loop;
1196: --
1197: -- Delete FF_ROUTES