eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 117: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa

113: FROM pay_action_information pai
114: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
115: AND action_context_type = 'AAP'
116: AND action_information3 = p_gre_org_id
117: AND EXISTS (SELECT 1 FROM pay_assignment_actions paa
118: WHERE paa.payroll_action_id = p_max_action_id
119: AND paa.assignment_action_id = pai.action_context_id)
120: AND pai.action_information1 = p_challan
121: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'

Line 324: FROM pay_assignment_actions paa

320: AND action_context_type = 'AAP'
321: AND action_information3 =p_gre_org_id
322: AND action_information1=p_challan_number
323: AND EXISTS ( SELECT 1
324: FROM pay_assignment_actions paa
325: WHERE paa.payroll_action_id = p_max_action_id
326: AND paa.assignment_action_id = pai.action_context_id)
327: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
328: ORDER BY action_information1, action_information2 ASC;

Line 471: ,pay_assignment_actions paa

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

Line 548: ,pay_assignment_actions paa

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

Line 758: ,pay_assignment_actions paa

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