DBA Data[Home] [Help]

APPS.PAY_PAYUSNAC_XMLP_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 141: pay_consolidation_sets b,

137: decode(c.PAYROLL_NAME,null,null,'-') ||
138: c.PAYROLL_NAME
139: into ret
140: from pay_payroll_actions a,
141: pay_consolidation_sets b,
142: pay_payrolls_f c
143: where a.CONSOLIDATION_SET_ID = b.CONSOLIDATION_SET_ID
144: and a.PAYROLL_ID = c.PAYROLL_ID (+)
145: and a.ACTION_TYPE = 'M'