APPS.PAY_US_MMREF_LOCAL dependencies on PAY_PAYROLL_ACTIONS

Line 100: pay_payroll_actions PPA,

96: -- + length('LOCALITY_CODE=')),
97: 'TRANSFER_STATE_CODE=P', substr(sr.jurisdiction_code,1,2)
98: FROM pay_state_rules SR,
99: hr_organization_information HOI,
100: pay_payroll_actions PPA,
101: pay_payroll_actions PPA1
102: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
103: ('TRANSFER_PAYROLL_ACTION_ID')
104: AND ppa1.effective_date = ppa.effective_date

Line 101: pay_payroll_actions PPA1

97: 'TRANSFER_STATE_CODE=P', substr(sr.jurisdiction_code,1,2)
98: FROM pay_state_rules SR,
99: hr_organization_information HOI,
100: pay_payroll_actions PPA,
101: pay_payroll_actions PPA1
102: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
103: ('TRANSFER_PAYROLL_ACTION_ID')
104: AND ppa1.effective_date = ppa.effective_date
105: --AND ppa1.report_qualifier = sr.state_code

Line 148: pay_payroll_actions ppa,

144: 'TAX_UNIT_NAME=P' , hou.name,
145: 'TRANSFER_EMP_CODE=P', 'R'
146: FROM
147: hr_all_organization_units hou,
148: pay_payroll_actions ppa,
149: pay_assignment_actions AA
150: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value
151: ('TRANSFER_PAYROLL_ACTION_ID')
152: AND ppa.report_type = 'YREND'

Line 190: pay_payroll_actions PA

186: FROM per_all_people_f PE,
187: per_all_assignments_f SS,
188: pay_action_interlocks AI,
189: pay_assignment_actions AA,
190: pay_payroll_actions PA
191: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
192: ('TRANSFER_PAYROLL_ACTION_ID') AND
193: AA.payroll_action_id = PA.payroll_action_id AND
194: AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 220: pay_payroll_actions ppa,

216: ff_archive_items fai,
217: ff_contexts fc, -- JD
218: ff_database_items fdi,
219: ff_archive_item_contexts faic, -- JD
220: pay_payroll_actions ppa,
221: pay_assignment_actions paa
222: where
223: paa.assignment_action_id =
224: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID')