DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on PER_ALL_ASSIGNMENTS_F

Line 433: ,per_all_assignments_f as1

429: ,pay_payroll_actions appa2
430: ,pay_assignment_actions act
431: ,pay_assignment_actions act1
432: ,pay_action_interlocks pai
433: ,per_all_assignments_f as1
434: ,hr_soft_coding_keyflex hsck
435: WHERE ppa.payroll_action_id = p_payroll_action_id
436: AND appa.effective_date BETWEEN l_start_date AND l_end_date
437: AND appa.action_type IN ('R','Q')

Line 486: ,per_all_assignments_f as1

482: ,pay_payroll_actions appa2
483: ,pay_assignment_actions act
484: ,pay_assignment_actions act1
485: ,pay_action_interlocks pai
486: ,per_all_assignments_f as1
487: ,hr_soft_coding_keyflex hsck
488: WHERE ppa.payroll_action_id = p_payroll_action_id
489: AND appa.effective_date BETWEEN l_start_date AND l_end_date
490: AND appa.action_type IN ('R','Q')

Line 512: FROM per_all_assignments_f asg1

508: --
509: CURSOR csr_get_mun_num(p_assignment_id NUMBER
510: ,p_effective_date DATE) IS
511: SELECT eev1.screen_entry_value screen_entry_value
512: FROM per_all_assignments_f asg1
513: ,per_all_assignments_f asg2
514: ,per_all_people_f per
515: ,pay_element_links_f el
516: ,pay_element_types_f et

Line 513: ,per_all_assignments_f asg2

509: CURSOR csr_get_mun_num(p_assignment_id NUMBER
510: ,p_effective_date DATE) IS
511: SELECT eev1.screen_entry_value screen_entry_value
512: FROM per_all_assignments_f asg1
513: ,per_all_assignments_f asg2
514: ,per_all_people_f per
515: ,pay_element_links_f el
516: ,pay_element_types_f et
517: ,pay_input_values_f iv1