DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PAY_STATE_RULES

Line 102: FROM pay_state_rules sr,

98: 'TR_DATE_EARNED=P', ppa.effective_date,
99: 'BUSINESS_GROUP_ID=P', ppa.business_group_id,
100: 'TRANSFER_STATE_CODE=P', substr (sr.jurisdiction_code, 1 , 2),
101: 'ROOT_XML_TAG=P', ''
102: FROM pay_state_rules sr,
103: hr_organization_information hoi,
104: pay_payroll_actions ppa
105: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID')
106: AND ppa.report_qualifier = 'LOCAL'