APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_PRE_PAYMENTS

Line 98: pay_pre_payments tables.

94: Fix for bug#2771166.
95: 30-JAN-2003 ssattini 115.17 Tuned the c_assignments cursor
96: to avoid full table scan on
97: pay_org_payment_method_f and
98: pay_pre_payments tables.
99: 03-FEB-2003 ssattini 115.18 2745577 Fixed the issue to print correct
100: Court Order/Case Number when
101: ran with multiple garnishment
102: elements for each assignment,

Line 698: ,pay_pre_payments ppp

694: ,pay_payment_types_tl ppt_tl
695: ,pay_payment_types ppt
696: ,pay_org_payment_methods_f_tl popm_tl
697: ,pay_org_payment_methods_f popm
698: ,pay_pre_payments ppp
699: ,(select distinct paa_pre.assignment_action_id /* Locked Action Id */
700: ,paa_run.tax_unit_id
701: ,ppa_pre.date_earned
702: ,paa_pre.assignment_id

Line 926: from pay_pre_payments ppp,

922: ,cp_pre_payment_id in number) is
923: select decode(ppa_pymt.action_type,
924: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
925: paa_pymt.serial_number)
926: from pay_pre_payments ppp,
927: pay_assignment_actions paa_pymt,
928: pay_payroll_actions ppa_pymt,
929: pay_action_interlocks pai
930: where pai.locked_action_id = cp_pre_payment_action