APPS.PAY_PAYCNSOE_XMLP_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 199: FROM pay_consolidation_sets pcs

195: AND P_START_DATE_T BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
196:
197: CURSOR csr_consolidation_name IS
198: SELECT pcs.consolidation_set_name
199: FROM pay_consolidation_sets pcs
200: WHERE pcs.consolidation_set_id = P_CONSOLIDATION_SET_ID
201: AND pcs.business_group_id = P_BUSINESS_GROUP_ID ;
202:
203: CURSOR csr_business_group IS