DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 370: ,pay_assignment_actions

366: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
367: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
368: AND action_context_id IN ( SELECT MAX(action_context_id)
369: FROM pay_action_information
370: ,pay_assignment_actions
371: WHERE action_information_category = 'IN_EOY_PERSON'
372: AND action_context_type = 'AAP'
373: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
374: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

Line 429: ,pay_assignment_actions

425: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
426: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
427: AND action_context_id IN ( SELECT MAX(action_context_id)
428: FROM pay_action_information
429: ,pay_assignment_actions
430: WHERE action_information_category = 'IN_EOY_PERSON'
431: AND action_context_type = 'AAP'
432: AND action_information2 = pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM')
433: AND action_information3 = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')