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 128: ,pay_assignment_actions pac

124: ,pay_element_types_f et
125: ,pay_input_values_f iv1
126: ,pay_element_entries_f ee
127: ,pay_element_entry_values_f eev1
128: ,pay_assignment_actions pac
129: ,fnd_sessions fs
130: ,pay_input_values_f_tl ivtl
131: WHERE per.person_id = asg1.person_id
132: AND asg2.person_id = per.person_id

Line 175: ,pay_assignment_actions pac

171: ,pay_element_types_f et
172: ,pay_input_values_f iv1
173: ,pay_element_entries_f ee
174: ,pay_element_entry_values_f eev1
175: ,pay_assignment_actions pac
176: ,fnd_sessions fs
177: ,pay_input_values_f_tl ivtl
178: WHERE per.person_id = asg1.person_id
179: AND asg2.person_id = per.person_id

Line 224: ,pay_assignment_actions pac

220: ,pay_element_types_f et
221: ,pay_input_values_f iv1
222: ,pay_element_entries_f ee
223: ,pay_element_entry_values_f eev1
224: ,pay_assignment_actions pac
225: ,fnd_sessions fs
226: ,pay_input_values_f_tl ivtl
227: WHERE per.person_id = asg1.person_id
228: AND asg2.person_id = per.person_id

Line 270: ,pay_assignment_actions pac

266: ,pay_element_types_f et
267: ,pay_input_values_f iv1
268: ,pay_element_entries_f ee
269: ,pay_element_entry_values_f eev1
270: ,pay_assignment_actions pac
271: ,fnd_sessions fs
272: ,pay_input_values_f_tl ivtl
273: WHERE per.person_id = asg1.person_id
274: AND asg2.person_id = per.person_id

Line 350: pay_assignment_actions pac,

346: IS
347: CURSOR csr_get_local_unit (p_assignment_action_id NUMBER) IS
348: select scl.segment2
349: from hr_soft_coding_keyflex scl,
350: pay_assignment_actions pac,
351: per_all_assignments_f ASSIGN,
352: pay_legislation_rules LEG,
353: fnd_id_flex_structures fstruct
354: Where pac.assignment_action_id = p_assignment_action_id

Line 435: ,pay_assignment_actions paa

431: ,pay_element_entry_values_f eev
432: ,pay_input_values_f piv
433: ,pay_element_types_f pet
434: ,per_all_assignments_f paaf
435: ,pay_assignment_actions paa
436: ,pay_payroll_actions ppa
437: WHERE paa.assignment_action_id = p_assignment_action_id
438: AND ppa.payroll_action_id = paa.payroll_action_id
439: AND pee.element_entry_id = eev.element_entry_id

Line 466: ,pay_assignment_actions assact

462: SELECT asg2.assignment_id
463: ,assact.payroll_action_id
464: FROM per_all_assignments_f asg1
465: ,per_all_assignments_f asg2
466: ,pay_assignment_actions assact
467: ,per_all_people_f pap
468: ,pay_payroll_actions ppa
469: WHERE assact.assignment_action_id = p_assignment_action_id
470: AND asg1.assignment_id = assact.assignment_id

Line 507: FROM pay_assignment_actions assact

503: -- Legislative changes 2007 : cursor to fetch the payroll action effective date
504:
505: CURSOR csr_get_payroll_action_date (p_assignment_action_id NUMBER) IS
506: SELECT ppa.effective_date , ppa.payroll_action_id , assact.assignment_id
507: FROM pay_assignment_actions assact
508: ,pay_payroll_actions ppa
509: WHERE assact.assignment_action_id = p_assignment_action_id
510: AND ppa.payroll_action_id = assact.payroll_action_id ;
511:

Line 517: FROM pay_assignment_actions assact ,

513: -- Legislative changes 2007 : cursor to fetch the Tax Municipality at Local Unit
514:
515: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
516: SELECT ORG_INFORMATION6 lu_tax_mun
517: FROM pay_assignment_actions assact ,
518: per_all_assignments_f paa ,
519: pay_payroll_actions ppa ,
520: hr_soft_coding_keyflex scl ,
521: hr_organization_information hoi

Line 750: ,pay_assignment_actions paa

746: --,sum(pai1.action_information4) value
747: ,pai1.action_information4 value
748: FROM pay_action_information pai
749: ,pay_action_information pai1
750: ,pay_assignment_actions paa
751: WHERE pai.action_context_type = 'PA'
752: AND pai.action_information_category = p_pa_category
753: AND pai1.action_context_type = 'AAP'
754: AND pai.action_information5 <> 'F'

Line 757: FROM pay_assignment_actions paa

753: AND pai1.action_context_type = 'AAP'
754: AND pai.action_information5 <> 'F'
755: AND pai1.action_information3 <> 'F'
756: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
757: FROM pay_assignment_actions paa
758: WHERE paa.source_action_id = p_action_context_id
759: AND paa.assignment_id = pai1.assignment_id
760: )
761: OR pai1.action_context_id = p_action_context_id)

Line 800: ,pay_assignment_actions paa

796: ,pai.action_information11 tax_basis_text
797: ,pai.action_information12 ele_class
798: FROM pay_action_information pai
799: ,pay_action_information pai1
800: ,pay_assignment_actions paa
801: WHERE pai.action_context_type = 'PA'
802: AND pai.action_information_category = p_pa_category
803: AND pai1.action_context_type = 'AAP'
804: AND pai.action_information5 <> 'F'

Line 807: FROM pay_assignment_actions paa

803: AND pai1.action_context_type = 'AAP'
804: AND pai.action_information5 <> 'F'
805: AND pai1.action_information3 <> 'F'
806: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
807: FROM pay_assignment_actions paa
808: WHERE paa.source_action_id = p_action_context_id
809: AND paa.assignment_id = pai1.assignment_id
810: )
811: OR pai1.action_context_id = p_action_context_id)

Line 836: ,pay_assignment_actions paa

832: --,sum(pai1.action_information4) value
833: ,pai1.action_information4 value
834: FROM pay_action_information pai
835: ,pay_action_information pai1
836: ,pay_assignment_actions paa
837: WHERE pai.action_context_type = 'PA'
838: AND pai.action_information_category = p_pa_category
839: AND pai1.action_context_type = 'AAP'
840: AND pai.action_information5 = 'F'

Line 843: FROM pay_assignment_actions paa

839: AND pai1.action_context_type = 'AAP'
840: AND pai.action_information5 = 'F'
841: AND pai1.action_information3 = 'F'
842: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
843: FROM pay_assignment_actions paa
844: WHERE paa.source_action_id = p_action_context_id
845: AND paa.assignment_id = pai1.assignment_id
846: )
847: OR pai1.action_context_id = p_action_context_id)

Line 886: ,pay_assignment_actions paa

882: ,pai.action_information11 tax_basis_text
883: ,pai.action_information12 ele_class
884: FROM pay_action_information pai
885: ,pay_action_information pai1
886: ,pay_assignment_actions paa
887: WHERE pai.action_context_type = 'PA'
888: AND pai.action_information_category = p_pa_category
889: AND pai1.action_context_type = 'AAP'
890: AND pai.action_information5 = 'F'

Line 893: FROM pay_assignment_actions paa

889: AND pai1.action_context_type = 'AAP'
890: AND pai.action_information5 = 'F'
891: AND pai1.action_information3 = 'F'
892: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
893: FROM pay_assignment_actions paa
894: WHERE paa.source_action_id = p_action_context_id
895: AND paa.assignment_id = pai1.assignment_id
896: )
897: OR pai1.action_context_id = p_action_context_id)

Line 930: FROM pay_assignment_actions paa

926: AND pai.action_context_type = 'AAP'
927: AND pai.action_information_category = p_category
928: AND (pai.action_context_id = p_action_context_id
929: OR pai.action_context_id = ( SELECT paa.source_action_id
930: FROM pay_assignment_actions paa
931: WHERE paa.assignment_action_id = p_action_context_id
932: AND paa.assignment_id = pai.Assignment_ID
933: ));
934:

Line 1394: ,pay_assignment_actions assact

1390: SELECT asg2.assignment_id
1391: ,assact.payroll_action_id
1392: FROM per_all_assignments_f asg1
1393: ,per_all_assignments_f asg2
1394: ,pay_assignment_actions assact
1395: ,per_all_people_f pap
1396: ,pay_payroll_actions ppa
1397: WHERE assact.assignment_action_id = p_assignment_action_id
1398: AND asg1.assignment_id = assact.assignment_id