APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 686: ,per_all_assignments_f paa

682: ,paa.assignment_number
683: ,to_char(papf.original_date_of_hire,'YYYY/MM/DD')
684: ,paa.assignment_id
685: from per_all_people_f papf
686: ,per_all_assignments_f paa
687: where paa.person_id = papf.person_id
688: and p_d between paa.effective_start_date and paa.effective_end_date
689: and p_d between papf.effective_start_date and papf.effective_end_date
690: and paa.primary_flag = 'Y'

Line 701: from per_all_assignments_f

697: select assignment_number
698: ,assignment_id
699: ,effective_start_date
700: ,min(abs(effective_start_date-p_d))
701: from per_all_assignments_f
702: where person_id = p_person_id
703: and primary_flag = 'Y'
704: and assignment_type = 'E'
705: group by assignment_number, assignment_id, effective_start_date;

Line 718: l_assignment_number PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;

714: and effective_end_date >= p_d;
715:
716:
717: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
718: l_assignment_number PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
719: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
720: l_hire_date VARCHAR2(30);
721: l_asg_start_date DATE;
722: l_min NUMBER;

Line 719: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

715:
716:
717: l_full_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
718: l_assignment_number PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
719: l_assignment_id PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
720: l_hire_date VARCHAR2(30);
721: l_asg_start_date DATE;
722: l_min NUMBER;
723:

Line 825: FROM PER_ALL_ASSIGNMENTS_F paa,

821:
822: cursor c_start_date
823: (p_person_id in NUMBER) is
824: SELECT min(paa.EFFECTIVE_START_DATE)
825: FROM PER_ALL_ASSIGNMENTS_F paa,
826: per_assignment_status_types typ
827: WHERE paa.PERSON_ID = p_person_id
828: AND paa.ASSIGNMENT_TYPE = 'E'
829: AND paa.PRIMARY_FLAG = 'Y'

Line 836: FROM PER_ALL_ASSIGNMENTS_F paa,

832:
833: cursor c_end_date
834: (p_person_id in NUMBER) is
835: SELECT max(paa.EFFECTIVE_END_DATE)
836: FROM PER_ALL_ASSIGNMENTS_F paa,
837: per_assignment_status_types typ
838: WHERE paa.PERSON_ID = p_person_id
839: AND paa.ASSIGNMENT_TYPE = 'E'
840: AND paa.PRIMARY_FLAG = 'Y'

Line 2388: PER_ALL_ASSIGNMENTS_F ASGT,

2384: from PAY_ELEMENT_TYPES_F ELEMENT,
2385: PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION,
2386: BEN_BENEFIT_CLASSIFICATIONS BENEFIT,
2387: PAY_ELEMENT_LINKS_F LINK,
2388: PER_ALL_ASSIGNMENTS_F ASGT,
2389: PER_PERIODS_OF_SERVICE SERVICE_PERIOD
2390: WHERE
2391: asgt.person_id = p_person_id and
2392: to_number(hav.attribute1) = ELEMENT.element_type_id