DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_PARTY_USG_ASSIGNMENTS_S

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 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)