DBA Data[Home] [Help]

APPS.PSP_EFFORTS_PKG dependencies on PSP_PAYROLL_LINES

Line 450: FROM psp_distribution_lines_history D,psp_payroll_sub_lines S, psp_payroll_lines L

446: D.suspense_org_account_id, --- N(9)
447: element_account_id, --- N(9)
448: org_schedule_id, --- N(9)
449: 'distribution_lines' source
450: FROM psp_distribution_lines_history D,psp_payroll_sub_lines S, psp_payroll_lines L
451: WHERE D.payroll_sub_line_id = S.payroll_sub_line_id AND
452: S.payroll_line_id = L.payroll_line_id AND
453: D.distribution_DATE between sdate AND edate AND
454: L.person_id = person_id1 AND

Line 537: psp_payroll_lines ppl,

533: org_schedule_id,
534: 'distribution_lines' source
535: FROM psp_distribution_lines_history pdlh,
536: psp_payroll_sub_lines pps,
537: psp_payroll_lines ppl,
538: psp_summary_lines psl
539: WHERE
540: psl.person_id = person_id1 AND
541: pdlh.summary_line_id = psl.summary_line_id AND