APPS.HZ_CUSTOMER_INT dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 3385: INSERT INTO hz_party_usg_assignments(

3381: )
3382: IS
3383:
3384: BEGIN
3385: INSERT INTO hz_party_usg_assignments(
3386: PARTY_USG_ASSIGNMENT_ID
3387: ,PARTY_ID
3388: ,PARTY_USAGE_CODE
3389: ,EFFECTIVE_START_DATE

Line 3406: SELECT hz_party_usg_assignments_s.nextval -- PARTY_USG_ASSIGNMENT_ID

3402: ,LAST_UPDATED_BY
3403: ,REQUEST_ID
3404: ,PROGRAM_APPLICATION_ID
3405: ,PROGRAM_ID )
3406: SELECT hz_party_usg_assignments_s.nextval -- PARTY_USG_ASSIGNMENT_ID
3407: ,hzp.party_id -- PARTY_ID
3408: ,'CUSTOMER' -- PARTY_USAGE_CODE
3409: ,trunc(SYSDATE) -- EFFECTIVE_START_DATE
3410: ,decode((select min(status)

Line 3461: INSERT INTO hz_party_usg_assignments(

3457: )
3458: IS
3459:
3460: BEGIN
3461: INSERT INTO hz_party_usg_assignments(
3462: PARTY_USG_ASSIGNMENT_ID
3463: ,PARTY_ID
3464: ,PARTY_USAGE_CODE
3465: ,EFFECTIVE_START_DATE

Line 3482: SELECT hz_party_usg_assignments_s.nextval -- PARTY_USG_ASSIGNMENT_ID

3478: ,LAST_UPDATED_BY
3479: ,REQUEST_ID
3480: ,PROGRAM_APPLICATION_ID
3481: ,PROGRAM_ID )
3482: SELECT hz_party_usg_assignments_s.nextval -- PARTY_USG_ASSIGNMENT_ID
3483: ,hzp.party_id -- PARTY_ID
3484: ,'CUSTOMER' -- PARTY_USAGE_CODE
3485: ,trunc(SYSDATE) -- EFFECTIVE_START_DATE
3486: ,decode((select min(status)

Line 3535: from hz_party_usg_assignments pua

3531: WHERE party_id = hzp.party_id
3532: AND request_id = p_request_id )
3533: and not exists(
3534: select '1'
3535: from hz_party_usg_assignments pua
3536: where pua.party_id = hzp.party_id
3537: and party_usage_code = 'CUSTOMER'
3538: and pua.status_flag = ( select min(status)
3539: from hz_cust_accounts