APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_DIMENSION_ROUTES

Line 510: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DIMENSION_ROUTES',NULL);

506: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_DIMENSIONS',NULL);
507: DELETE hr_s_balance_dimensions;
508: COMMIT;
509:
510: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DIMENSION_ROUTES',NULL);
511: DELETE hr_s_dimension_routes;
512: COMMIT;
513:
514: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_SETS',NULL);

Line 511: DELETE hr_s_dimension_routes;

507: DELETE hr_s_balance_dimensions;
508: COMMIT;
509:
510: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DIMENSION_ROUTES',NULL);
511: DELETE hr_s_dimension_routes;
512: COMMIT;
513:
514: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_SETS',NULL);
515: DELETE hr_s_element_sets;

Line 1178: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Dimension Routes', 'HR_S_DIMENSION_ROUTES');

1174:
1175: --Dimension Routes
1176:
1177: write_log('LOG',NULL,NULL,NULL);
1178: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Dimension Routes', 'HR_S_DIMENSION_ROUTES');
1179: FOR rec IN get_dimension_routes_csr LOOP
1180:
1181:
1182: INSERT INTO hr_s_dimension_routes

Line 1182: INSERT INTO hr_s_dimension_routes

1178: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Dimension Routes', 'HR_S_DIMENSION_ROUTES');
1179: FOR rec IN get_dimension_routes_csr LOOP
1180:
1181:
1182: INSERT INTO hr_s_dimension_routes
1183: ( balance_dimension_id
1184: ,route_id
1185: ,route_type
1186: ,priority

Line 1223: UPDATE hr_s_dimension_routes

1219:
1220: /* IF tax unit is not installed
1221: then update run dimension to _ASG_RUN
1222: */
1223: UPDATE hr_s_dimension_routes
1224: SET run_dimension_id =
1225: (
1226: SELECT balance_dimension_id
1227: FROM hr_s_balance_dimensions