DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FND_SESSIONS

Line 3463: , fnd_sessions SES

3459: from
3460: per_all_assignments_f ASSIGN
3461: , per_all_people_f PEOPLE
3462: , per_person_types PTYPE
3463: , fnd_sessions SES
3464: where l_date_earned BETWEEN ASSIGN.effective_start_date
3465: AND ASSIGN.effective_end_date
3466: and ASSIGN.assignment_id = l_asgid
3467: and PEOPLE.person_id = ASSIGN.person_id

Line 3488: fnd_sessions SES

3484: begin
3485: select PHONE.phone_number
3486: into l_employee_phone_no
3487: from per_phones PHONE ,
3488: fnd_sessions SES
3489: where PHONE.parent_id (+) = l_person_id
3490: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
3491: and PHONE.phone_type (+)= 'W1'
3492: and l_date_earned BETWEEN NVL(PHONE.date_from,SES.effective_date)