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_NO_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 62: ,pay_assignment_actions paa

58: ,pay_element_entry_values_f eev
59: ,pay_input_values_f piv
60: ,pay_element_types_f pet
61: ,per_all_assignments_f paaf
62: ,pay_assignment_actions paa
63: ,pay_payroll_actions ppa
64: WHERE paa.assignment_action_id = p_assignment_action_id
65: AND ppa.payroll_action_id = paa.payroll_action_id
66: AND pee.element_entry_id = eev.element_entry_id

Line 134: ,pay_assignment_actions pac

130: ,pay_element_types_f et
131: ,pay_input_values_f iv1
132: ,pay_element_entries_f ee
133: ,pay_element_entry_values_f eev1
134: ,pay_assignment_actions pac
135: ,fnd_sessions fs
136: ,pay_input_values_f_tl ivtl
137: WHERE per.person_id = asg1.person_id
138: AND asg2.person_id = per.person_id

Line 181: ,pay_assignment_actions pac

177: ,pay_element_types_f et
178: ,pay_input_values_f iv1
179: ,pay_element_entries_f ee
180: ,pay_element_entry_values_f eev1
181: ,pay_assignment_actions pac
182: ,fnd_sessions fs
183: ,pay_input_values_f_tl ivtl
184: WHERE per.person_id = asg1.person_id
185: AND asg2.person_id = per.person_id

Line 230: ,pay_assignment_actions pac

226: ,pay_element_types_f et
227: ,pay_input_values_f iv1
228: ,pay_element_entries_f ee
229: ,pay_element_entry_values_f eev1
230: ,pay_assignment_actions pac
231: ,fnd_sessions fs
232: ,pay_input_values_f_tl ivtl
233: WHERE per.person_id = asg1.person_id
234: AND asg2.person_id = per.person_id

Line 276: ,pay_assignment_actions pac

272: ,pay_element_types_f et
273: ,pay_input_values_f iv1
274: ,pay_element_entries_f ee
275: ,pay_element_entry_values_f eev1
276: ,pay_assignment_actions pac
277: ,fnd_sessions fs
278: ,pay_input_values_f_tl ivtl
279: WHERE per.person_id = asg1.person_id
280: AND asg2.person_id = per.person_id

Line 356: pay_assignment_actions pac,

352: IS
353: CURSOR csr_get_local_unit (p_assignment_action_id NUMBER) IS
354: select scl.segment2
355: from hr_soft_coding_keyflex scl,
356: pay_assignment_actions pac,
357: per_all_assignments_f ASSIGN,
358: pay_legislation_rules LEG,
359: fnd_id_flex_structures fstruct
360: Where pac.assignment_action_id = p_assignment_action_id

Line 441: ,pay_assignment_actions paa

437: ,pay_element_entry_values_f eev
438: ,pay_input_values_f piv
439: ,pay_element_types_f pet
440: ,per_all_assignments_f paaf
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: WHERE paa.assignment_action_id = p_assignment_action_id
444: AND ppa.payroll_action_id = paa.payroll_action_id
445: AND pee.element_entry_id = eev.element_entry_id

Line 472: ,pay_assignment_actions assact

468: SELECT asg2.assignment_id
469: ,assact.payroll_action_id
470: FROM per_all_assignments_f asg1
471: ,per_all_assignments_f asg2
472: ,pay_assignment_actions assact
473: ,per_all_people_f pap
474: ,pay_payroll_actions ppa
475: WHERE assact.assignment_action_id = p_assignment_action_id
476: AND asg1.assignment_id = assact.assignment_id

Line 513: FROM pay_assignment_actions assact

509: -- Legislative changes 2007 : cursor to fetch the payroll action effective date
510:
511: CURSOR csr_get_payroll_action_date (p_assignment_action_id NUMBER) IS
512: SELECT ppa.effective_date , ppa.payroll_action_id , assact.assignment_id
513: FROM pay_assignment_actions assact
514: ,pay_payroll_actions ppa
515: WHERE assact.assignment_action_id = p_assignment_action_id
516: AND ppa.payroll_action_id = assact.payroll_action_id ;
517:

Line 523: FROM pay_assignment_actions assact ,

519: -- Legislative changes 2007 : cursor to fetch the Tax Municipality at Local Unit
520:
521: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
522: SELECT ORG_INFORMATION6 lu_tax_mun
523: FROM pay_assignment_actions assact ,
524: per_all_assignments_f paa ,
525: pay_payroll_actions ppa ,
526: hr_soft_coding_keyflex scl ,
527: hr_organization_information hoi

Line 756: ,pay_assignment_actions paa

752: --,sum(pai1.action_information4) value
753: ,pai1.action_information4 value
754: FROM pay_action_information pai
755: ,pay_action_information pai1
756: ,pay_assignment_actions paa
757: WHERE pai.action_context_type = 'PA'
758: AND pai.action_information_category = p_pa_category
759: AND pai1.action_context_type = 'AAP'
760: AND pai.action_information5 <> 'F'

Line 763: FROM pay_assignment_actions paa

759: AND pai1.action_context_type = 'AAP'
760: AND pai.action_information5 <> 'F'
761: AND pai1.action_information3 <> 'F'
762: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
763: FROM pay_assignment_actions paa
764: WHERE paa.source_action_id = p_action_context_id
765: AND paa.assignment_id = pai1.assignment_id
766: )
767: OR pai1.action_context_id = p_action_context_id)

Line 806: ,pay_assignment_actions paa

802: ,pai.action_information11 tax_basis_text
803: ,pai.action_information12 ele_class
804: FROM pay_action_information pai
805: ,pay_action_information pai1
806: ,pay_assignment_actions paa
807: WHERE pai.action_context_type = 'PA'
808: AND pai.action_information_category = p_pa_category
809: AND pai1.action_context_type = 'AAP'
810: AND pai.action_information5 <> 'F'

Line 814: FROM pay_assignment_actions paa

810: AND pai.action_information5 <> 'F'
811: AND pai1.action_information3 <> 'F'
812: -- Tuned Cursors FOR Bug - 8345827
813: /*AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
814: FROM pay_assignment_actions paa
815: WHERE paa.source_action_id = p_action_context_id
816: AND paa.assignment_id = pai1.assignment_id
817: )
818: OR pai1.action_context_id = p_action_context_id)*/

Line 845: ,pay_assignment_actions paa

841: --,sum(pai1.action_information4) value
842: ,pai1.action_information4 value
843: FROM pay_action_information pai
844: ,pay_action_information pai1
845: ,pay_assignment_actions paa
846: WHERE pai.action_context_type = 'PA'
847: AND pai.action_information_category = p_pa_category
848: AND pai1.action_context_type = 'AAP'
849: AND pai.action_information5 = 'F'

Line 852: FROM pay_assignment_actions paa

848: AND pai1.action_context_type = 'AAP'
849: AND pai.action_information5 = 'F'
850: AND pai1.action_information3 = 'F'
851: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
852: FROM pay_assignment_actions paa
853: WHERE paa.source_action_id = p_action_context_id
854: AND paa.assignment_id = pai1.assignment_id
855: )
856: OR pai1.action_context_id = p_action_context_id)

Line 895: ,pay_assignment_actions paa

891: ,pai.action_information11 tax_basis_text
892: ,pai.action_information12 ele_class
893: FROM pay_action_information pai
894: ,pay_action_information pai1
895: ,pay_assignment_actions paa
896: WHERE pai.action_context_type = 'PA'
897: AND pai.action_information_category = p_pa_category
898: AND pai1.action_context_type = 'AAP'
899: AND pai.action_information5 = 'F'

Line 903: FROM pay_assignment_actions paa

899: AND pai.action_information5 = 'F'
900: AND pai1.action_information3 = 'F'
901: -- Tuned Cursor FOR Bug - 8345827
902: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
903: FROM pay_assignment_actions paa
904: WHERE paa.source_action_id = p_action_context_id
905: AND paa.assignment_id = pai1.assignment_id
906: )
907: OR pai1.action_context_id = p_action_context_id)*/

Line 943: FROM pay_assignment_actions paa

939: AND pai.action_context_id=p_action_context_id; -- Tuned Cursor FOR Bug - 8345827
940: -- Removed the query below for Bug 8345827
941: /* AND (pai.action_context_id = p_action_context_id
942: OR pai.action_context_id = ( SELECT paa.source_action_id
943: FROM pay_assignment_actions paa
944: WHERE paa.assignment_action_id = p_action_context_id
945: AND paa.assignment_id = pai.Assignment_ID
946: )); */
947:

Line 1407: ,pay_assignment_actions assact

1403: SELECT asg2.assignment_id
1404: ,assact.payroll_action_id
1405: FROM per_all_assignments_f asg1
1406: ,per_all_assignments_f asg2
1407: ,pay_assignment_actions assact
1408: ,per_all_people_f pap
1409: ,pay_payroll_actions ppa
1410: WHERE assact.assignment_action_id = p_assignment_action_id
1411: AND asg1.assignment_id = assact.assignment_id