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 436: ,pay_payroll_actions ppa

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

Line 468: ,pay_payroll_actions ppa

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

Line 488: ,pay_payroll_actions ppa

484: FROM pay_element_entries_f pee
485: ,pay_element_entry_values_f eev
486: ,pay_input_values_f piv
487: ,pay_element_types_f pet
488: ,pay_payroll_actions ppa
489: WHERE ppa.payroll_action_id = pay_act_id
490: AND pee.element_entry_id = eev.element_entry_id
491: AND eev.input_value_id + 0 = piv.input_value_id
492: AND piv.name = 'Tax Municipality'

Line 508: ,pay_payroll_actions ppa

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

Line 519: pay_payroll_actions ppa ,

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

Line 538: ,pay_payroll_actions ppa

534: FROM pay_element_entries_f pee
535: ,pay_element_entry_values_f eev
536: ,pay_input_values_f piv
537: ,pay_element_types_f pet
538: ,pay_payroll_actions ppa
539: WHERE ppa.payroll_action_id = pay_act_id
540: AND pee.assignment_id = p_asg_id
541: AND pet.element_name = 'Employer Contribution Information'
542: AND pet.legislation_code = 'NO'

Line 1396: ,pay_payroll_actions ppa

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

Line 1415: ,pay_payroll_actions ppa

1411: FROM pay_element_entries_f pee
1412: ,pay_element_entry_values_f eev
1413: ,pay_input_values_f piv
1414: ,pay_element_types_f pet
1415: ,pay_payroll_actions ppa
1416: WHERE ppa.payroll_action_id = pay_act_id
1417: AND pee.element_entry_id = eev.element_entry_id
1418: AND eev.input_value_id + 0 = piv.input_value_id
1419: AND piv.name = 'Tax Municipality'