APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_BALANCE_DIMENSIONS

Line 126: ,hr_s_balance_dimensions pbd

122:
123: CURSOR get_balance_dimensions_csr IS
124: SELECT distinct balance_dimension_id, dimension_name
125: FROM hr_s_application_ownerships ao
126: ,hr_s_balance_dimensions pbd
127: ,fnd_product_installations b
128: ,fnd_application c
129: WHERE pbd.legislation_code ='ZZ'
130: AND ao.key_name = 'BALANCE_DIMENSION_ID'

Line 143: ,hr_s_balance_dimensions pbd

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'
147: AND ao.key_name = 'ROUTE_ID'

Line 205: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');

201:
202: -- write output file for Balance Dimensions to be Installed.
203:
204: write_log('OUTPUT',NULL,NULL,NULL);
205: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');
206:
207: FOR rec IN get_balance_dimensions_csr LOOP
208: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Balance Dimension', rec.dimension_name);
209: END LOOP;

Line 448: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_DIMENSIONS',NULL);

444: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_FEEDS_F',NULL);
445: DELETE hr_s_balance_feeds_f;
446: COMMIT;
447:
448: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_DIMENSIONS',NULL);
449: DELETE hr_s_balance_dimensions;
450: COMMIT;
451:
452: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_SETS',NULL);

Line 449: DELETE hr_s_balance_dimensions;

445: DELETE hr_s_balance_feeds_f;
446: COMMIT;
447:
448: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_DIMENSIONS',NULL);
449: DELETE hr_s_balance_dimensions;
450: COMMIT;
451:
452: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_SETS',NULL);
453: DELETE hr_s_element_sets;

Line 955: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');

951:
952: --Balance Dimensions
953:
954: write_log('LOG',NULL,NULL,NULL);
955: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');
956: FOR rec IN get_balance_dimensions_csr LOOP
957: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Dimension', rec.dimension_name);
958:
959: INSERT INTO hr_s_balance_dimensions

Line 959: INSERT INTO hr_s_balance_dimensions

955: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Dimensions', 'HR_S_BALANCE_DIMENSIONS');
956: FOR rec IN get_balance_dimensions_csr LOOP
957: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Dimension', rec.dimension_name);
958:
959: INSERT INTO hr_s_balance_dimensions
960: ( balance_dimension_id
961: ,business_group_id
962: ,legislation_code
963: ,route_id

Line 1046: FROM hr_s_balance_dimensions

1042:
1043: DELETE FROM hr_s_application_ownerships
1044: WHERE key_name = 'BALANCE_DIMENSION_ID'
1045: AND TO_NUMBER(key_value) IN (SELECT balance_dimension_id
1046: FROM hr_s_balance_dimensions
1047: WHERE legislation_code = 'ZZ'
1048: AND INSTR(database_item_suffix,'_TU_') > 0);
1049:
1050: END IF;

Line 1463: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_DIMENSIONS',NULL);

1459:
1460:
1461: --Updating Balance Dimensions Table
1462:
1463: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_DIMENSIONS',NULL);
1464: UPDATE hr_s_balance_dimensions
1465: SET legislation_code = p_legislation_code
1466: WHERE legislation_code = 'ZZ';
1467:

Line 1464: UPDATE hr_s_balance_dimensions

1460:
1461: --Updating Balance Dimensions Table
1462:
1463: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_DIMENSIONS',NULL);
1464: UPDATE hr_s_balance_dimensions
1465: SET legislation_code = p_legislation_code
1466: WHERE legislation_code = 'ZZ';
1467:
1468: --Updating Legislation Rules Table