APPS.PSP_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 913: per_assignment_status_types binner

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
917: AND binner.per_system_status = 'ACTIVE_ASSIGN'

Line 925: per_assignment_status_types b

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
929: AND b.per_system_status = 'ACTIVE_ASSIGN'

Line 2834: from per_assignment_status_types past ,

2830: l_effective_date date;
2831:
2832: cursor fetch_asg_status_csr(P_ASSIGNMENT_ID IN NUMBER,P_EFFECTIVE_DATE IN DATE )is
2833: select past.USER_STATUS
2834: from per_assignment_status_types past ,
2835: per_assignments_f paf
2836: where paf.assignment_id = p_assignment_id
2837: and past.ASSIGNMENT_STATUS_TYPE_ID = paf.ASSIGNMENT_STATUS_TYPE_ID
2838: and p_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 2840: L_USER_STATUS per_assignment_status_types. USER_STATUS%TYPE;

2836: where paf.assignment_id = p_assignment_id
2837: and past.ASSIGNMENT_STATUS_TYPE_ID = paf.ASSIGNMENT_STATUS_TYPE_ID
2838: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
2839:
2840: L_USER_STATUS per_assignment_status_types. USER_STATUS%TYPE;
2841:
2842: begin
2843:
2844: open eff_dates_csr;