APPS.PAY_NO_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 63: ,pay_payroll_actions ppa

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
67: AND eev.input_value_id + 0 = piv.input_value_id

Line 442: ,pay_payroll_actions ppa

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
446: AND eev.input_value_id + 0 = piv.input_value_id

Line 474: ,pay_payroll_actions ppa

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
477: AND pap.person_id = asg1.person_id
478: AND asg2.person_id = pap.person_id

Line 494: ,pay_payroll_actions ppa

490: FROM pay_element_entries_f pee
491: ,pay_element_entry_values_f eev
492: ,pay_input_values_f piv
493: ,pay_element_types_f pet
494: ,pay_payroll_actions ppa
495: WHERE ppa.payroll_action_id = pay_act_id
496: AND pee.element_entry_id = eev.element_entry_id
497: AND eev.input_value_id + 0 = piv.input_value_id
498: AND piv.name = 'Tax Municipality'

Line 514: ,pay_payroll_actions ppa

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:
518:

Line 525: pay_payroll_actions ppa ,

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
528: WHERE assact.assignment_action_id = p_assignment_action_id
529: AND ppa.payroll_action_id = assact.payroll_action_id

Line 544: ,pay_payroll_actions ppa

540: FROM pay_element_entries_f pee
541: ,pay_element_entry_values_f eev
542: ,pay_input_values_f piv
543: ,pay_element_types_f pet
544: ,pay_payroll_actions ppa
545: WHERE ppa.payroll_action_id = pay_act_id
546: AND pee.assignment_id = p_asg_id
547: AND pet.element_name = 'Employer Contribution Information'
548: AND pet.legislation_code = 'NO'

Line 1409: ,pay_payroll_actions ppa

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
1412: AND pap.person_id = asg1.person_id
1413: AND asg2.person_id = pap.person_id

Line 1428: ,pay_payroll_actions ppa

1424: FROM pay_element_entries_f pee
1425: ,pay_element_entry_values_f eev
1426: ,pay_input_values_f piv
1427: ,pay_element_types_f pet
1428: ,pay_payroll_actions ppa
1429: WHERE ppa.payroll_action_id = pay_act_id
1430: AND pee.element_entry_id = eev.element_entry_id
1431: AND eev.input_value_id + 0 = piv.input_value_id
1432: AND piv.name = 'Tax Municipality'