APPS.PAY_IP_STARTUP_UTIL dependencies on FND_APPLICATION

Line 81: ,fnd_application c

77: SELECT distinct classification_id, legislation_code, classification_name
78: FROM hr_s_element_classifications pec
79: ,hr_s_application_ownerships ao
80: ,fnd_product_installations b
81: ,fnd_application c
82: WHERE nvl(legislation_code,'X') = 'ZZ'
83: AND ao.key_name = 'CLASSIFICATION_ID'
84: AND TO_NUMBER(ao.key_value) = pec.classification_id
85: AND ao.product_name = c.application_short_name

Line 96: ,fnd_application c

92: SELECT distinct balance_type_id, currency_code, balance_name
93: FROM hr_s_balance_types pbt
94: ,hr_s_application_ownerships ao
95: ,fnd_product_installations b
96: ,fnd_application c
97: WHERE pbt.legislation_code = 'ZZ'
98: AND ao.key_name = 'BALANCE_TYPE_ID'
99: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
100: AND ao.product_name = c.application_short_name

Line 112: ,fnd_application c

108: FROM hr_s_defined_balances pdb
109: ,hr_s_balance_types pbt
110: ,hr_s_application_ownerships ao
111: ,fnd_product_installations b
112: ,fnd_application c
113: WHERE pdb.legislation_code ='ZZ'
114: AND ao.key_name = 'DEFINED_BALANCE_ID'
115: AND pbt.balance_type_id = pdb.balance_type_id
116: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id

Line 128: ,fnd_application c

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'
131: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
132: AND ao.product_name = c.application_short_name

Line 145: ,fnd_application c

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'
148: AND TO_NUMBER(ao.key_value) = fr.route_id
149: AND fr.route_id = pbd.route_id

Line 1220: FROM FND_APPLICATION

1216: BEGIN
1217:
1218: SELECT application_id
1219: INTO l_application_id
1220: FROM FND_APPLICATION
1221: WHERE application_short_name = p_appl_Short_Name;
1222:
1223: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1224: fnd_flex_key_api.set_session_mode('seed_data');

Line 1273: FROM FND_APPLICATION

1269: shorthand_length => p_shorthand_length);
1270:
1271: SELECT application_id
1272: INTO l_application_id
1273: FROM FND_APPLICATION
1274: WHERE application_short_name = p_appl_short_name;
1275:
1276: SELECT NVL(MAX(ifs.id_flex_num),0) + 1
1277: INTO l_structure.structure_number