DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FND_SESSIONS

Line 5076: , fnd_sessions SES

5072: from
5073: per_all_assignments_f ASSIGN
5074: , per_all_people_f PEOPLE
5075: , per_person_types PTYPE
5076: , fnd_sessions SES
5077: where l_date_earned BETWEEN ASSIGN.effective_start_date
5078: AND ASSIGN.effective_end_date
5079: and ASSIGN.assignment_id = l_asgid
5080: and PEOPLE.person_id = ASSIGN.person_id

Line 5101: fnd_sessions SES

5097: begin
5098: select PHONE.phone_number
5099: into l_employee_phone_no
5100: from per_phones PHONE ,
5101: fnd_sessions SES
5102: where PHONE.parent_id (+) = l_person_id
5103: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
5104: and PHONE.phone_type (+)= 'W1'
5105: and l_date_earned BETWEEN NVL(PHONE.date_from,SES.effective_date)