APPS.BEN_DT_TRGR_HANDLE dependencies on PER_ALL_ASSIGNMENTS_F

Line 555: from per_all_assignments_f

551: ,ASS_ATTRIBUTE27
552: ,ASS_ATTRIBUTE28
553: ,ASS_ATTRIBUTE29
554: ,ASS_ATTRIBUTE30
555: from per_all_assignments_f
556: where rowid = p_rowid;
557: --
558: begin
559: --

Line 792: from per_all_assignments_f

788: where person_id = p_person_id;
789: --
790: cursor c2 is
791: select *
792: from per_all_assignments_f
793: where person_id = p_person_id
794: and assignment_type = 'B'
795: and primary_flag = 'Y'
796: --

Line 805: from per_all_assignments_f asg

801: order by effective_start_date;
802: --
803: cursor c3 is
804: select null
805: from per_all_assignments_f asg
806: where asg.person_id = p_person_id
807: and asg.effective_start_date = p_pds_atd + 1
808: and assignment_type = 'B'
809: and primary_flag = 'Y';

Line 996: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',

992: -- Bug : 3865655 Changed datetrack mode from ZAP to 3865655
993:
994: dt_api.Find_DT_Del_Modes
995: (p_effective_date => l_c2.effective_start_date,
996: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',
997: p_base_key_column => 'ASSIGNMENT_ID',
998: p_base_key_value => l_c2.assignment_id,
999: p_zap => l_zap_mode,
1000: p_delete => l_delete_mode,