DBA Data[Home] [Help]

APPS.PSP_PSPRCDLS_XMLP_PKG dependencies on PSP_PAYROLL_CONTROLS

Line 260: PSP_PAYROLL_CONTROLS PPC,

256: ,0)) DL_DEBIT_AMOUNT,
257: B.SUSPENSE_REASON_CODE
258: FROM
259: PSP_SUMMARY_LINES A,
260: PSP_PAYROLL_CONTROLS PPC,
261: PSP_DISTRIBUTION_LINES_HISTORY B
262: WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
263: AND PPC.PAYROLL_CONTROL_ID = A.PAYROLL_CONTROL_ID
264: AND PPC.CURRENCY_CODE = CF_1FORMULA.CURRENCY_CODE

Line 291: PSP_PAYROLL_CONTROLS PPC,

287: ,0)) DL_DEBIT_AMOUNT,
288: B.SUSPENSE_REASON_CODE
289: FROM
290: PSP_SUMMARY_LINES A,
291: PSP_PAYROLL_CONTROLS PPC,
292: PSP_DISTRIBUTION_LINES_HISTORY B
293: WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
294: AND PPC.PAYROLL_CONTROL_ID = A.PAYROLL_CONTROL_ID
295: AND PPC.CURRENCY_CODE = CF_1FORMULA.CURRENCY_CODE