APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 95: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa

91: FROM pay_action_information pai
92: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
93: AND action_context_type = 'AAP'
94: AND action_information3 = p_gre_org_id
95: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa
96: WHERE paa.payroll_action_id = p_max_action_id
97: AND paa.assignment_action_id = pai.action_context_id)
98: AND pai.action_information1 = p_challan
99: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'

Line 296: FROM pay_assignment_actions paa

292: AND action_context_type = 'AAP'
293: AND action_information3 =p_gre_org_id
294: AND action_information1=p_challan_number
295: AND EXISTS ( SELECT 1
296: FROM pay_assignment_actions paa
297: WHERE paa.payroll_action_id = p_max_action_id
298: AND paa.assignment_action_id = pai.action_context_id)
299: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
300: ORDER BY action_information1, action_information2 ASC;

Line 443: ,pay_assignment_actions paa

439: AND action_information2 = p_assess_period
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

Line 520: ,pay_assignment_actions paa

516: AND action_information3 = p_gre_org_id
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

Line 728: ,pay_assignment_actions paa

724: CURSOR csr_get_max_cont_id IS
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