APPS.PSP_PSPRCLSL_XMLP_PKG dependencies on PSP_PAYROLL_LINES

Line 61: FROM psp_payroll_lines ppl,

57: SELECT sum(decode(ppl.dr_cr_flag, 'C',ppsl.pay_amount,0)) sl_Credit_Amount,
58: sum(decode(ppl.dr_cr_flag, 'D',ppsl.pay_amount,0)) sl_Debit_Amount
59: INTO cp_credit_amount_sl,
60: v_debit_amount_sl
61: FROM psp_payroll_lines ppl,
62: psp_payroll_controls ppc,
63: psp_payroll_sub_lines ppsl
64: WHERE ppl.payroll_control_id = ppc.payroll_control_id
65: AND ppl.payroll_line_id = ppsl.payroll_line_id