DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 50: in pay_payroll_actions to improve

46: 25-sep-2003 ardsouza 115.11 2554865 Changes for Enhancement
47: to reconcile 1099R specific
48: balances
49: 22-jan-2004 ardsouza 115.12 3361925 Suppressed index on effective_date
50: in pay_payroll_actions to improve
51: performance.
52:
53: */
54:

Line 740: FROM pay_payroll_actions ppa, -- Year End

736: IS
737: SELECT assignment_action_id ,
738: serial_number ,
739: tax_unit_id
740: FROM pay_payroll_actions ppa, -- Year End
741: pay_assignment_actions paa, -- Year End
742: per_assignments_f paf
743: WHERE ppa.report_type = 'YREND'
744: AND ppa.action_status = 'C'

Line 768: pay_payroll_actions ppa,

764: SELECT paa.assignment_action_id
765: FROM
766: pay_assignment_actions paa,
767: per_assignments_f paf,
768: pay_payroll_actions ppa,
769: pay_action_classifications pac
770: WHERE paf.person_id = c_person_id
771: AND paa.assignment_id = paf.assignment_id
772: AND paa.tax_unit_id = c_tax_unit_id