APPS.PAY_JP_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 872: pay_payroll_actions ppa,

868: pai.action_information6 + pai.action_information9 + pai.action_information12 + pai.action_information20 + pai.action_information14, NULL))),0) PREV_SWOT_SI_PREM,
869: nvl(sum(decode(pai.action_information13, 'TERM',
870: NULL, decode(pai.action_information21, cp_itax_organization_id, pai.action_information14, NULL))), 0) PREV_SWOT_MUTUAL_AID
871: from pay_assignment_actions paa,
872: pay_payroll_actions ppa,
873: pay_action_information pai,
874: per_all_assignments_f pa
875: where paa.assignment_id = p_assignment_id
876: /* Below conditions have already been taken care in Pre-Tax Archiver

Line 901: pay_payroll_actions ppa2

897: and not exists(
898: select NULL /* Removed the hint as per Bug# 5033800 */
899: from pay_action_interlocks pai2,
900: pay_assignment_actions paa2,
901: pay_payroll_actions ppa2
902: where pai2.locked_action_id = paa.assignment_action_id
903: and paa2.assignment_action_id = pai2.locking_action_id
904: and ppa2.payroll_action_id = paa2.payroll_action_id
905: and ppa2.action_type = 'V');