APPS.HXC_TCSUMMARY_MIGRATE dependencies on PER_ALL_PEOPLE_F

Line 530: from per_all_people_f per

526: htb.start_time >= nvl(p_start_date, htb.start_time) and
527: htb.stop_time <= nvl(p_end_date, htb.stop_time) and
528: exists
529: (select 1
530: from per_all_people_f per
531: where htb.resource_id = per.person_id);
532:
533: CURSOR C_Resource_Id_Bg is
534: SELECT DISTINCT htb.time_building_block_id

Line 555: from per_all_people_f per

551: htb.start_time >= nvl(p_start_date, htb.start_time) and
552: htb.stop_time <= nvl(p_end_date, htb.stop_time) and
553: exists
554: (select 1
555: from per_all_people_f per
556: where htb.resource_id = per.person_id and
557: per.business_group_id = p_business_group_id);
558: BEGIN
559:

Line 777: from per_all_people_f per

773: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
774: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date
775: exists
776: (select 1
777: from per_all_people_f per
778: where tbb.resource_id = per.person_id);
779:
780: cursor c_templates_bg(p_start_date date, p_end_date date) is
781: select tbb.time_building_block_id

Line 796: from per_all_people_f per

792: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
793: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date
794: exists
795: (select 1
796: from per_all_people_f per
797: where tbb.resource_id = per.person_id and
798: per.business_group_id = p_business_group_id);
799:
800:

Line 997: from per_all_people_f per

993: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
994: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date
995: exists
996: (select 1
997: from per_all_people_f per
998: where tbb.resource_id = per.person_id);
999:
1000: cursor c_timecards_bg(p_start_date date, p_end_date date) is
1001: select tbb.time_building_block_id

Line 1015: from per_all_people_f per

1011: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
1012: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date
1013: exists
1014: (select 1
1015: from per_all_people_f per
1016: where tbb.resource_id = per.person_id and
1017: per.business_group_id = p_business_group_id);
1018:
1019: cursor c_app_periods(p_start_date date, p_end_date date) is

Line 1039: from per_all_people_f per

1035: where aps.application_period_id = tbb.time_building_block_id and
1036: aps.application_period_ovn = tbb.object_version_number) and
1037: exists
1038: (select 1
1039: from per_all_people_f per
1040: where tbb.resource_id = person_id )
1041: order by 1;
1042:
1043: cursor c_app_periods_bg(p_start_date date, p_end_date date) is

Line 1063: from per_all_people_f per

1059: where aps.application_period_id = tbb.time_building_block_id and
1060: aps.application_period_ovn = tbb.object_version_number) and
1061: exists
1062: (select 1
1063: from per_all_people_f per
1064: where tbb.resource_id = person_id and
1065: per.business_group_id =
1066: p_business_group_id)
1067: order by 1;