APPS.OKS_MASSCHANGE_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 13349: FROM HZ_CUST_ACCOUNT_ROLES CAR,

13345:
13346: CURSOR get_line_contact(p_attr_code IN Varchar2) IS
13347: SELECT SUBSTRB(P.PERSON_LAST_NAME,1,50) || ', ' ||
13348: SUBSTRB(P.PERSON_FIRST_NAME,1,40) NAME
13349: FROM HZ_CUST_ACCOUNT_ROLES CAR,
13350: HZ_PARTIES P,
13351: --NPALEPU
13352: --29-JUN-2005
13353: --TCA Project

Line 13376: --Replaced dates check with status check as the 'Begin_date' and 'End_date' columns of hz_cust_account_roles table are migrated to 'Status' column

13372: AND P.PARTY_ID = PR.SUBJECT_ID
13373: --NPALEPU
13374: --29-JUN-2005
13375: --TCA Project
13376: --Replaced dates check with status check as the 'Begin_date' and 'End_date' columns of hz_cust_account_roles table are migrated to 'Status' column
13377: /* AND DECODE(SIGN(TRUNC(sysdate) -
13378: TRUNC(NVL(car.begin_date,sysdate))),-1,'I', DECODE(SIGN(TRUNC(sysdate) -
13379: TRUNC(NVL(car.end_date,sysdate))),1,'I','A')) = 'A' */
13380: AND car.status = 'A'