[Home] [Help]
82: CURSOR get_element_class_csr IS
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
97: CURSOR get_balance_type_csr IS
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
113: SELECT distinct defined_balance_id, pbt.balance_name bname
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
129: CURSOR get_balance_dimensions_csr IS
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
146: SELECT distinct fr.route_id, route_name
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
3139:
3140:
3141:
3142: CURSOR csr_payroll_installed is
3143: select 1 from fnd_product_installations
3144: where application_id = 801
3145: and status = 'I';
3146:
3147: cursor csr_flex_struct (p_id_flex_num number) is