APPS.HXC_TIMECARD_DEPOSIT dependencies on PER_ALL_ASSIGNMENTS_F

Line 885: FROM per_all_assignments_f

881: p_evaluation_date IN date,
882: p_dividing_factor IN number)
883: IS
884: SELECT normal_hours/p_dividing_factor
885: FROM per_all_assignments_f
886: WHERE person_id =p_reource_id
887: AND assignment_type in ('E','C')
888: AND primary_flag = 'Y'
889: AND p_evaluation_date BETWEEN effective_start_date AND effective_end_Date;

Line 1245: FROM per_all_assignments_f

1241:
1242: cursor c_check_bussiness_group_id(p_person_id number, p_timecard_start_date date) is
1243: SELECT business_group_id,
1244: organization_id
1245: FROM per_all_assignments_f
1246: WHERE person_id = p_person_id
1247: AND assignment_type IN('E', 'C')
1248: AND primary_flag = 'Y'
1249: AND p_timecard_start_date BETWEEN effective_start_date AND effective_end_date;

Line 1251: l_business_group_id per_all_assignments_f.business_group_id%type;

1247: AND assignment_type IN('E', 'C')
1248: AND primary_flag = 'Y'
1249: AND p_timecard_start_date BETWEEN effective_start_date AND effective_end_date;
1250:
1251: l_business_group_id per_all_assignments_f.business_group_id%type;
1252: l_organization_id per_all_assignments_f.organization_id%type;
1253:
1254:
1255: Begin

Line 1252: l_organization_id per_all_assignments_f.organization_id%type;

1248: AND primary_flag = 'Y'
1249: AND p_timecard_start_date BETWEEN effective_start_date AND effective_end_date;
1250:
1251: l_business_group_id per_all_assignments_f.business_group_id%type;
1252: l_organization_id per_all_assignments_f.organization_id%type;
1253:
1254:
1255: Begin
1256: