DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on PER_EMPLOYEES_CURRENT_X

Line 6292: (SELECT employee_id FROM per_employees_current_x

6288: decode(cws.OWNER_PARTY_TYPE,
6289: 'HZ_PARTIES',
6290: (SELECT party_id FROM hz_parties WHERE party_number = cws.OWNER_PARTY_NUM),
6291: 'EMPLOYEE',
6292: (SELECT employee_id FROM per_employees_current_x
6293: WHERE employee_num = cws.OWNER_PARTY_NUM
6294: AND full_name = cws.OWNER_NAME),
6295: 'PO_VENDORS',
6296: (SELECT vendor_id FROM po_vendors WHERE segment1 = cws.OWNER_PARTY_NUM

Line 6321: (SELECT employee_id FROM per_employees_current_x

6317: 'HZ_PARTIES',
6318: (SELECT party_id FROM hz_parties
6319: WHERE party_number = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER),
6320: 'EMPLOYEE',
6321: (SELECT employee_id FROM per_employees_current_x
6322: WHERE employee_num = cws.ASSOCIATE_BILL_TO_PARTY_NUMBER
6323: AND full_name = cws.ASSOCIATE_BILL_TO_PARTY_NAME),
6324: 'PO_VENDORS',
6325: (SELECT vendor_id FROM po_vendors

Line 6351: (SELECT employee_id FROM per_employees_current_x

6347: 'HZ_PARTIES',
6348: (SELECT party_id FROM hz_parties
6349: WHERE party_number = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER),
6350: 'EMPLOYEE',
6351: (SELECT employee_id FROM per_employees_current_x
6352: WHERE employee_num = cws.ASSOCIATE_SHIP_TO_PARTY_NUMBER
6353: AND full_name = cws.ASSOCIATE_SHIP_TO_PARTY_NAME),
6354: 'PO_VENDORS',
6355: (SELECT vendor_id FROM po_vendors