DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 444: ,per_assignments_f asg

440: AND action_information3 = p_gre_org_id
441: AND action_context_id IN (SELECT MAX(pai.action_context_id)
442: FROM pay_action_information pai
443: ,pay_assignment_actions paa
444: ,per_assignments_f asg
445: WHERE pai.action_information_category = 'IN_24Q_PERSON'
446: AND pai.action_context_type = 'AAP'
447: AND pai.action_information1 = asg.person_id
448: AND pai.assignment_id = asg.assignment_id

Line 521: ,per_assignments_f asg

517: AND assignment_id = p_assignment_id
518: AND action_context_id IN ( SELECT MAX(action_context_id)
519: FROM pay_action_information pai
520: ,pay_assignment_actions paa
521: ,per_assignments_f asg
522: WHERE action_information_category = 'IN_24Q_PERSON'
523: AND action_context_type = 'AAP'
524: AND pai.action_information1 = asg.person_id
525: AND SUBSTR(pai.action_information2,1,9) = p_assess_year

Line 729: ,per_assignments_f asg

725: SELECT MAX(pai.action_context_id) action_cont_id
726: ,source_id sour_id
727: FROM pay_action_information pai
728: ,pay_assignment_actions paa
729: ,per_assignments_f asg
730: WHERE pai.action_information_category = 'IN_24Q_PERSON'
731: AND pai.action_information3 = p_gre_org_id
732: AND pai.action_information2 = p_assess_period
733: AND pai.action_information1 = asg.person_id