DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 863: pay_payroll_actions ppa,

859: pai.action_information6 + pai.action_information9 + pai.action_information12 + pai.action_information20 + pai.action_information14, NULL))),0) PREV_SWOT_SI_PREM,
860: nvl(sum(decode(pai.action_information13, 'TERM',
861: NULL, decode(pai.action_information21, cp_itax_organization_id, pai.action_information14, NULL))), 0) PREV_SWOT_MUTUAL_AID
862: from pay_assignment_actions paa,
863: pay_payroll_actions ppa,
864: pay_action_information pai,
865: per_all_assignments_f pa
866: where paa.assignment_id = p_assignment_id
867: /* Below conditions have already been taken care in Pre-Tax Archiver

Line 892: pay_payroll_actions ppa2

888: and not exists(
889: select NULL /* Removed the hint as per Bug# 5033800 */
890: from pay_action_interlocks pai2,
891: pay_assignment_actions paa2,
892: pay_payroll_actions ppa2
893: where pai2.locked_action_id = paa.assignment_action_id
894: and paa2.assignment_action_id = pai2.locking_action_id
895: and ppa2.payroll_action_id = paa2.payroll_action_id
896: and ppa2.action_type = 'V');