APPS.AP_WEB_CC_VALIDATIONS_PKG dependencies on PER_EMPLOYEES_X

Line 671: from per_employees_x pap, financials_system_parameters fsp

667: end if;
668:
669: if (l_full_name is null or trim(l_full_name) is null) then
670: select substrb(full_name, 1, 80) into l_full_name
671: from per_employees_x pap, financials_system_parameters fsp
672: where pap.business_group_id = fsp.business_group_id
673: and pap.employee_id = p_employee_id
674: and rownum = 1;
675: end if;

Line 847: PER_EMPLOYEES_X P

843: SET CATEGORY = ''PERSONAL''
844: WHERE CATEGORY <> ''PERSONAL''
845: AND EXISTS (SELECT 1
846: FROM AP_CARDS_ALL CARD,
847: PER_EMPLOYEES_X P
848: WHERE AP_WEB_DB_HR_INT_PKG.IsPersonTerminated(CARD.employee_id)=''Y''
849: AND CARD.employee_id=P.employee_id
850: AND P.inactive_date < CC.transaction_date
851: AND CARD.card_program_id=CC.card_program_id