APPS.AP_WEB_CC_VALIDATIONS_PKG dependencies on PER_EMPLOYEES_X

Line 634: from per_employees_x pap, financials_system_parameters fsp

630: begin
631: select full_name into l_full_name from ap_card_details where card_id = p_card_id;
632: if (l_full_name is null) then
633: select substrb(full_name, 1, 80) into l_full_name
634: from per_employees_x pap, financials_system_parameters fsp
635: where pap.business_group_id = fsp.business_group_id
636: and pap.employee_id = p_employee_id;
637: end if;
638:

Line 806: PER_EMPLOYEES_X P

802: SET CATEGORY = ''PERSONAL''
803: WHERE CATEGORY <> ''PERSONAL''
804: AND EXISTS (SELECT 1
805: FROM AP_CARDS_ALL CARD,
806: PER_EMPLOYEES_X P
807: WHERE AP_WEB_DB_HR_INT_PKG.IsPersonTerminated(CARD.employee_id)=''Y''
808: AND CARD.employee_id=P.employee_id
809: AND P.inactive_date < CC.transaction_date
810: AND CARD.card_program_id=CC.card_program_id