APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 635: From per_all_assignments_f asg, per_periods_of_service per

631: --For bug 7229852: Added new cursor
632: CURSOR csr_get_atd
633: IS
634: Select actual_termination_date
635: From per_all_assignments_f asg, per_periods_of_service per
636: Where asg.assignment_id = p_assignment_id
637: And per.period_of_service_id = asg.period_of_service_id
638: AND p_effective_date between asg.effective_start_date and asg.effective_end_date;
639:

Line 813: IF (l_chg_table_name = 'PER_ALL_ASSIGNMENTS_F'

809: --For Bug 7229852: Start
810: g_act_term_date := NULL;
811: --For Bug 7229852: End
812:
813: IF (l_chg_table_name = 'PER_ALL_ASSIGNMENTS_F'
814: AND l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID'
815: AND l_update_type in ('U','C') --For bug 7229852: Added Correction event
816: )
817: THEN