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: 17-nov-2011 emunisek 115.13 13326069 Made changes to Functions populate_balance_id,
53: populate_balance_value and get_live_value to
54: calculate Federal Wages based on Direct US

Line 829: FROM pay_payroll_actions ppa, -- Year End

825: IS
826: SELECT assignment_action_id ,
827: serial_number ,
828: tax_unit_id
829: FROM pay_payroll_actions ppa, -- Year End
830: pay_assignment_actions paa, -- Year End
831: per_assignments_f paf
832: WHERE ppa.report_type = 'YREND'
833: AND ppa.action_status = 'C'

Line 857: pay_payroll_actions ppa,

853: SELECT paa.assignment_action_id
854: FROM
855: pay_assignment_actions paa,
856: per_assignments_f paf,
857: pay_payroll_actions ppa,
858: pay_action_classifications pac
859: WHERE paf.person_id = c_person_id
860: AND paa.assignment_id = paf.assignment_id
861: AND paa.tax_unit_id = c_tax_unit_id