APPS.HXC_TCD_XML_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 108: FROM per_all_assignments_f

104:
105: l_EvalDateSql := 'SELECT GREATEST(:1,tmp.start_date)
106: FROM
107: (SELECT min(effective_start_date) start_date
108: FROM per_all_assignments_f
109: WHERE person_id = :2
110: AND assignment_type IN (''E'', ''C'')
111: AND primary_flag = ''Y''
112: AND ((trunc(effective_start_date) <= trunc(:3)

Line 115: FROM per_all_assignments_f

111: AND primary_flag = ''Y''
112: AND ((trunc(effective_start_date) <= trunc(:3)
113: AND trunc(effective_end_date) >= trunc(:4))
114: OR (effective_start_date = (SELECT min(effective_start_date)
115: FROM per_all_assignments_f
116: WHERE person_id = :5
117: AND assignment_type IN (''E'', ''C'')
118: AND primary_flag = ''Y''
119: AND trunc(effective_start_date) > trunc(:6)

Line 222: FROM per_all_assignments_f

218: AND TRUNC(stop_time) <= p_period_end_date)
219: )
220: AND EXISTS
221: (SELECT 'Y'
222: FROM per_all_assignments_f
223: WHERE person_id = p_person_id
224: AND assignment_type IN('E','C')
225: AND primary_flag = 'Y'
226: AND trunc(effective_start_date) <= trunc(p_period_start_date)

Line 243: FROM per_all_assignments_f

239: END IF;
240:
241: -- Get the max of effective start date, this will pick up the timecards for mid period rehires which are NOT ENTERED
242: l_sql := 'SELECT max(effective_start_date)
243: FROM per_all_assignments_f
244: WHERE person_id = :1
245: AND assignment_type IN (''E'', ''C'')
246: AND primary_flag = ''Y''
247: AND ((effective_start_date <= :2

Line 374: FROM per_all_assignments_f

370: l_prev_rec_period := l_rec_period;
371: l_index := l_pref_table.NEXT(l_index);
372: END LOOP;
373: SELECT max(effective_end_date) INTO l_tc_end_date
374: FROM per_all_assignments_f
375: WHERE person_id = p_person_id
376: and effective_end_date >= g_tc_start_date
377: and primary_flag = 'Y'
378: and assignment_type in ('E','C');

Line 474: FROM per_all_assignments_f paaf

470: (SELECT person_id AS
471: resource_id,
472: NULL timecard_id,
473: NULL approval_status
474: FROM per_all_assignments_f paaf
475: WHERE person_id IN(';
476:
477: FOR i IN 1..p_person_ids.count
478: LOOP

Line 531: FROM per_all_assignments_f

527: AND TRUNC(start_time) > :31
528: AND TRUNC(stop_time) <= :41) )
529: AND EXISTS
530: (SELECT ''Y''
531: FROM per_all_assignments_f
532: WHERE person_id = paaf.person_id
533: AND assignment_type IN(''E'', ''C'')
534: AND primary_flag = ''Y''
535: AND((TRUNC(effective_start_date) <= :5

Line 772: FROM per_all_assignments_f paaf

768:
769:
770:
771: l_directsSQL := 'SELECT DISTINCT person_id
772: FROM per_all_assignments_f paaf
773: WHERE assignment_type IN (''E'', ''C'')
774: AND primary_flag = ''Y''
775: AND supervisor_id = :1
776: AND (

Line 794: FROM per_all_assignments_f paaf

790:
791: */
792:
793: l_directsSQL := 'SELECT DISTINCT person_id
794: FROM per_all_assignments_f paaf
795: WHERE assignment_type IN (''E'', ''C'')
796: AND primary_flag = ''Y''
797: AND supervisor_id = :1
798: AND trunc(effective_start_date) <= :2

Line 836: FROM per_all_assignments_f asgn

832:
833:
834: ELSE
835: l_allEmpSQL := 'SELECT distinct person_id
836: FROM per_all_assignments_f asgn
837: WHERE person_id <> :1
838: AND primary_flag = ''Y''
839: AND assignment_type in (''E'',''C'')';
840: