APPS.PAY_IP_STARTUP_UTIL dependencies on FND_APPLICATION

Line 87: ,fnd_application c

83: SELECT distinct classification_id, legislation_code, classification_name
84: FROM hr_s_element_classifications pec
85: ,hr_s_application_ownerships ao
86: ,fnd_product_installations b
87: ,fnd_application c
88: WHERE nvl(legislation_code,'X') = 'ZZ'
89: AND ao.key_name = 'CLASSIFICATION_ID'
90: AND TO_NUMBER(ao.key_value) = pec.classification_id
91: AND ao.product_name = c.application_short_name

Line 102: ,fnd_application c

98: SELECT distinct balance_type_id, currency_code, balance_name
99: FROM hr_s_balance_types pbt
100: ,hr_s_application_ownerships ao
101: ,fnd_product_installations b
102: ,fnd_application c
103: WHERE pbt.legislation_code = 'ZZ'
104: AND ao.key_name = 'BALANCE_TYPE_ID'
105: AND TO_NUMBER(ao.key_value) = pbt.balance_type_id
106: AND ao.product_name = c.application_short_name

Line 118: ,fnd_application c

114: FROM hr_s_defined_balances pdb
115: ,hr_s_balance_types pbt
116: ,hr_s_application_ownerships ao
117: ,fnd_product_installations b
118: ,fnd_application c
119: WHERE pdb.legislation_code ='ZZ'
120: AND ao.key_name = 'DEFINED_BALANCE_ID'
121: AND pbt.balance_type_id = pdb.balance_type_id
122: AND TO_NUMBER(ao.key_value) = pdb.defined_balance_id

Line 134: ,fnd_application c

130: SELECT distinct balance_dimension_id, dimension_name
131: FROM hr_s_application_ownerships ao
132: ,hr_s_balance_dimensions pbd
133: ,fnd_product_installations b
134: ,fnd_application c
135: WHERE pbd.legislation_code ='ZZ'
136: AND ao.key_name = 'BALANCE_DIMENSION_ID'
137: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
138: AND ao.product_name = c.application_short_name

Line 151: ,fnd_application c

147: FROM hr_s_application_ownerships ao
148: ,hr_s_routes fr
149: ,hr_s_balance_dimensions pbd
150: ,fnd_product_installations b
151: ,fnd_application c
152: WHERE pbd.legislation_code ='ZZ'
153: AND ao.key_name = 'ROUTE_ID'
154: AND TO_NUMBER(ao.key_value) = fr.route_id
155: AND fr.route_id = pbd.route_id

Line 1589: FROM FND_APPLICATION

1585: BEGIN
1586:
1587: SELECT application_id
1588: INTO l_application_id
1589: FROM FND_APPLICATION
1590: WHERE application_short_name = p_appl_Short_Name;
1591:
1592: hr_utility.set_location('pay_ip_startup_util.create_key_flexfield ',10);
1593: fnd_flex_key_api.set_session_mode('seed_data');

Line 1642: FROM FND_APPLICATION

1638: shorthand_length => p_shorthand_length);
1639:
1640: SELECT application_id
1641: INTO l_application_id
1642: FROM FND_APPLICATION
1643: WHERE application_short_name = p_appl_short_name;
1644:
1645: SELECT NVL(MAX(ifs.id_flex_num),0) + 1
1646: INTO l_structure.structure_number