APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_STATE_RULES

Line 87: FROM pay_state_rules SR,

83: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
84: 'TRANSFER_COUNTY=P', '-1',
85: 'TRANSFER_2678_FILER=P', 'N',
86: 'PAYROLL_ACTION_ID=C', PPA.payroll_action_id
87: FROM pay_state_rules SR,
88: hr_organization_information HOI,
89: pay_payroll_actions PPA
90: WHERE HOI.organization_id =
91: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')

Line 207: FROM pay_state_rules SR,

203: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
204: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
205: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
206: 'BUSINESS_GROUP_ID=C', PA.business_group_id
207: FROM pay_state_rules SR,
208: pay_payroll_actions PA,
209: pay_assignment_actions AA,
210: pay_payroll_actions PA1
211: WHERE PA1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 234: pay_state_rules SR,

230: (PA.effective_date, AA.assignment_id)),
231: 'JURISDICTION_CODE=C', SR.jurisdiction_code
232: FROM per_people_f PE,
233: per_assignments_f SS,
234: pay_state_rules SR,
235: pay_action_interlocks AI,
236: pay_assignment_actions AA,
237: pay_payroll_actions PA
238: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value