DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 472: ,per_assignments_f asg

468: AND action_information3 = p_gre_org_id
469: AND action_context_id IN (SELECT MAX(pai.action_context_id)
470: FROM pay_action_information pai
471: ,pay_assignment_actions paa
472: ,per_assignments_f asg
473: WHERE pai.action_information_category = 'IN_24Q_PERSON'
474: AND pai.action_context_type = 'AAP'
475: AND pai.action_information1 = asg.person_id
476: AND pai.assignment_id = asg.assignment_id

Line 549: ,per_assignments_f asg

545: AND assignment_id = p_assignment_id
546: AND action_context_id IN ( SELECT MAX(action_context_id)
547: FROM pay_action_information pai
548: ,pay_assignment_actions paa
549: ,per_assignments_f asg
550: WHERE action_information_category = 'IN_24Q_PERSON'
551: AND action_context_type = 'AAP'
552: AND pai.action_information1 = asg.person_id
553: AND SUBSTR(pai.action_information2,1,9) = p_assess_year

Line 759: ,per_assignments_f asg

755: SELECT MAX(pai.action_context_id) action_cont_id
756: ,source_id sour_id
757: FROM pay_action_information pai
758: ,pay_assignment_actions paa
759: ,per_assignments_f asg
760: WHERE pai.action_information_category = 'IN_24Q_PERSON'
761: AND pai.action_information3 = p_gre_org_id
762: AND pai.action_information2 = p_assess_period
763: AND pai.action_information1 = asg.person_id