APPS.PAY_IP_STARTUP_UTIL dependencies on FND_PRODUCT_INSTALLATIONS

Line 80: ,fnd_product_installations b

76: CURSOR get_element_class_csr IS
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

Line 95: ,fnd_product_installations b

91: CURSOR get_balance_type_csr IS
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

Line 111: ,fnd_product_installations b

107: SELECT distinct defined_balance_id, pbt.balance_name bname
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

Line 127: ,fnd_product_installations b

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

Line 144: ,fnd_product_installations b

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

Line 1997: select 1 from fnd_product_installations

1993: l_segment_used NUMBER;--Bug#4938455. Changed varchar2 to number.
1994: l_structure_code fnd_id_flex_structures.id_flex_structure_code%type;
1995:
1996: CURSOR csr_payroll_installed is
1997: select 1 from fnd_product_installations
1998: where application_id = 801
1999: and status = 'I';
2000:
2001: cursor csr_flex_struct (p_id_flex_num number) is