DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_WEB_DB_HR_INT_PKG

Line 476: WHERE AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='N'

472: h.first_name,
473: h.business_group_id,
474: h.location_id
475: FROM per_employees_x h
476: WHERE AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='N'
477: UNION ALL
478: SELECT
479: h.person_id employee_id,
480: h.full_name,

Line 787: is_person_cwk := AP_WEB_DB_HR_INT_PKG.IsPersonCwk(l_invoice_rec.employee_id);

783: 'Oracle Project Accounting') then
784: l_invoice_rec.vendor_id := l_invoice_rec.header_vendor_id;
785: END IF;
786:
787: is_person_cwk := AP_WEB_DB_HR_INT_PKG.IsPersonCwk(l_invoice_rec.employee_id);
788:
789: IF is_person_cwk = 'Y' THEN
790: -------------------------------------------------------------------
791: l_debug_info := 'Validate Site if employee is a contingent worker';

Line 1262: l_is_contigent_worker := AP_WEB_DB_HR_INT_PKG.IsPersonCwk(l_invoice_rec.employee_id);

1258: IF g_debug_switch = 'Y' THEN
1259: fnd_file.put_line(fnd_file.log, l_debug_info);
1260: END IF;
1261:
1262: l_is_contigent_worker := AP_WEB_DB_HR_INT_PKG.IsPersonCwk(l_invoice_rec.employee_id);
1263:
1264: IF l_is_contigent_worker = 'N' THEN
1265:
1266: ----------------------------------------------------------