APPS.BEN_DT_TRGR_HANDLE dependencies on PER_ALL_ASSIGNMENTS_F

Line 554: from per_all_assignments_f

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

Line 716: from per_all_assignments_f

712: where person_id = p_person_id;
713: --
714: cursor c2 is
715: select *
716: from per_all_assignments_f
717: where person_id = p_person_id
718: and assignment_type = 'B'
719: and primary_flag = 'Y'
720: --

Line 729: from per_all_assignments_f asg

725: order by effective_start_date;
726: --
727: cursor c3 is
728: select null
729: from per_all_assignments_f asg
730: where asg.person_id = p_person_id
731: and asg.effective_start_date = p_pds_atd + 1
732: and assignment_type = 'B'
733: and primary_flag = 'Y';

Line 920: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',

916: -- Bug : 3865655 Changed datetrack mode from ZAP to 3865655
917:
918: dt_api.Find_DT_Del_Modes
919: (p_effective_date => l_c2.effective_start_date,
920: p_base_table_name => 'PER_ALL_ASSIGNMENTS_F',
921: p_base_key_column => 'ASSIGNMENT_ID',
922: p_base_key_value => l_c2.assignment_id,
923: p_zap => l_zap_mode,
924: p_delete => l_delete_mode,