APPS.PAY_CA_T4A_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 61: pay_payroll_actions PPA

57: Select 'TAX_UNIT_ID=C', hoi.organization_id,
58: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id ,
59: 'SBMT_REF_ID=P',to_char(ppa.payroll_action_id)
60: FROM hr_organization_information hoi,
61: pay_payroll_actions PPA
62: WHERE
63: hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
64: and hoi.org_information_context='Fed Magnetic Reporting'
65: and ppa.report_type = 'T4A' -- T4A Archiver Report Type

Line 89: pay_payroll_actions ppa,

85: 'TRANSFER_PACT_ID=P',to_char(ppa.payroll_action_id),
86: 'TRANSFER_TAX_UNIT_ID=P', to_char(AA.tax_unit_id)
87: From ff_archive_items fai,
88: ff_database_items fdi,
89: pay_payroll_actions ppa,
90: pay_assignment_actions AA
91: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
92: and ppa.report_type = 'T4A'
93: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

Line 120: pay_payroll_actions ppa

116: per_all_people_f ppf,
117: per_all_assignments_f paf,
118: pay_action_interlocks pai,
119: pay_assignment_actions paa,
120: pay_payroll_actions ppa
121: Where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
122: AND paa.payroll_action_id = ppa.payroll_action_id
123: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
124: AND pai.locking_action_id = paa.assignment_action_id