APPS.PAY_NO_ARC_RSEA_07 dependencies on PER_ALL_ASSIGNMENTS_F

Line 447: ,per_all_assignments_f as1

443: ,pay_payroll_actions appa2
444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1
446: ,pay_action_interlocks pai
447: ,per_all_assignments_f as1
448: ,hr_soft_coding_keyflex hsck
449: WHERE ppa.payroll_action_id = p_payroll_action_id
450: AND appa.effective_date BETWEEN l_start_date AND l_end_date
451: AND appa.action_type IN ('R','Q')

Line 501: ,per_all_assignments_f as1

497: ,pay_payroll_actions appa2
498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1
500: ,pay_action_interlocks pai
501: ,per_all_assignments_f as1
502: ,hr_soft_coding_keyflex hsck
503: WHERE ppa.payroll_action_id = p_payroll_action_id
504: AND appa.effective_date BETWEEN l_start_date AND l_end_date
505: AND appa.action_type IN ('R','Q')

Line 534: per_all_assignments_f paaf,

530: p_legal_employer_id NUMBER) IS
531: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
532: FROM pay_assignment_actions paa,
533: pay_payroll_actions ppa,
534: per_all_assignments_f paaf,
535: hr_soft_coding_keyflex hsck
536: WHERE ppa.payroll_action_id = paa.payroll_action_id
537: and paa.assignment_id = paaf.assignment_id
538: and ppa.action_type in ('R','Q')

Line 550: FROM per_all_assignments_f asg1

546: --
547: CURSOR csr_get_mun_num(p_assignment_id NUMBER
548: ,p_effective_date DATE) IS
549: SELECT eev1.screen_entry_value screen_entry_value
550: FROM per_all_assignments_f asg1
551: ,per_all_assignments_f asg2
552: ,per_all_people_f per
553: ,pay_element_links_f el
554: ,pay_element_types_f et

Line 551: ,per_all_assignments_f asg2

547: CURSOR csr_get_mun_num(p_assignment_id NUMBER
548: ,p_effective_date DATE) IS
549: SELECT eev1.screen_entry_value screen_entry_value
550: FROM per_all_assignments_f asg1
551: ,per_all_assignments_f asg2
552: ,per_all_people_f per
553: ,pay_element_links_f el
554: ,pay_element_types_f et
555: ,pay_input_values_f iv1