APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_ROUTES

Line 142: ,hr_s_routes fr

138:
139: CURSOR get_routes_csr IS
140: SELECT distinct fr.route_id, route_name
141: FROM hr_s_application_ownerships ao
142: ,hr_s_routes fr
143: ,hr_s_balance_dimensions pbd
144: ,fnd_product_installations b
145: ,fnd_application c
146: WHERE pbd.legislation_code ='ZZ'

Line 214: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');

210:
211: -- write output file for Balance Dimensions to be Installed.
212:
213: write_log('OUTPUT',NULL,NULL,NULL);
214: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');
215:
216: FOR rec IN get_routes_csr LOOP
217: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
218: END LOOP;

Line 364: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);

360: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_FORMULAS_F',NULL);
361: DELETE hr_s_formulas_f;
362: COMMIT;
363:
364: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);
365: DELETE hr_s_routes;
366: COMMIT;
367:
368: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);

Line 365: DELETE hr_s_routes;

361: DELETE hr_s_formulas_f;
362: COMMIT;
363:
364: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTES',NULL);
365: DELETE hr_s_routes;
366: COMMIT;
367:
368: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ROUTE_CONTEXT_USAGES',NULL);
369: DELETE hr_s_route_context_usages;

Line 1006: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');

1002:
1003: --Routes
1004:
1005: write_log('LOG',NULL,NULL,NULL);
1006: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');
1007: FOR rec IN get_routes_csr LOOP
1008: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
1009:
1010: INSERT INTO hr_s_routes

Line 1010: INSERT INTO hr_s_routes

1006: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Routes', 'HR_S_ROUTES');
1007: FOR rec IN get_routes_csr LOOP
1008: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
1009:
1010: INSERT INTO hr_s_routes
1011: ( route_id
1012: ,route_name
1013: ,user_defined_flag
1014: ,description

Line 1067: FROM hr_s_routes b

1063: ,parameter_name
1064: ,sequence_no
1065: FROM ff_route_parameters a
1066: WHERE EXISTS ( SELECT NULL
1067: FROM hr_s_routes b
1068: WHERE b.route_id = a.route_id));
1069: write_log('LOG',NULL,NULL,NULL);
1070: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Route Context Usages', 'HR_S_ROUTE_CONTEXT_USAGES');
1071: INSERT INTO hr_s_route_context_usages

Line 1078: FROM hr_s_routes b

1074: ,context_id
1075: ,sequence_no
1076: FROM ff_route_context_usages a
1077: WHERE EXISTS ( SELECT NULL
1078: FROM hr_s_routes b
1079: WHERE b.route_id = a.route_id));
1080:
1081: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',70);
1082: