APPS.PSP_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 469: per_all_assignments_f ASSIGN

465: LEAST(assign.effective_end_date, high_date)
466: FROM pay_user_tables PUT,
467: pay_user_columns PUC,
468: hr_soft_coding_keyflex target,
469: per_all_assignments_f ASSIGN
470: WHERE PUC.USER_COLUMN_ID (+) = target.SEGMENT4
471: AND high_date >= ASSIGN.effective_start_date
472: AND low_date <= ASSIGN.effective_end_date
473: AND ASSIGN.assignment_id = p_assignment_id

Line 912: FROM per_all_assignments_f ainner,

908:
909: CURSOR active_assign_cur
910: IS
911: SELECT count(*)
912: FROM per_all_assignments_f ainner,
913: per_assignment_status_types binner
914: WHERE ainner.person_id = p_person_id
915: AND ainner.primary_flag = 'Y'
916: AND ainner.assignment_status_type_id= binner.assignment_status_type_id

Line 924: FROM per_all_assignments_f a,

920:
921: CURSOR effective_date_cur
922: IS
923: SELECT max(a.effective_end_date)
924: FROM per_all_assignments_f a,
925: per_assignment_status_types b
926: WHERE a.person_id = p_person_id
927: AND a.primary_flag = 'Y'
928: AND a.assignment_status_type_id = b.assignment_status_type_id

Line 1259: FROM per_all_assignments_f paf

1255: RETURN VARCHAR2 IS
1256:
1257: CURSOR c1 IS
1258: SELECT assignment_number
1259: FROM per_all_assignments_f paf
1260: WHERE paf.assignment_id = p_assignment_id
1261: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
1262: AND period_of_service_id IS NOT NULL;
1263: