APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 503: From per_all_assignments_f asg, per_periods_of_service per

499: --For bug 7229852: Added new cursor
500: CURSOR csr_get_atd
501: IS
502: Select actual_termination_date
503: From per_all_assignments_f asg, per_periods_of_service per
504: Where asg.assignment_id = p_assignment_id
505: And per.period_of_service_id = asg.period_of_service_id
506: AND p_effective_date between asg.effective_start_date and asg.effective_end_date;
507:

Line 668: IF (l_chg_table_name = 'PER_ALL_ASSIGNMENTS_F'

664: --For Bug 7229852: Start
665: g_act_term_date := NULL;
666: --For Bug 7229852: End
667:
668: IF (l_chg_table_name = 'PER_ALL_ASSIGNMENTS_F'
669: AND l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
670: AND l_update_type in ('U','C') --For bug 7229852: Added Correction event
671: )
672: THEN