APPS.HZ_BES_BO_UTIL_PKG dependencies on HZ_BES_GT

Line 3750: FROM HZ_BUS_OBJ_TRACKING t, hz_bes_gt tmp

3746: DECODE ( tmp.event_type_flag, 'U', cp_perc_upd_evt_id, cp_perc_ins_evt_id)
3747: WHEN 'ORG_CUST' THEN
3748: DECODE ( tmp.event_type_flag, 'U', cp_orgc_upd_evt_id, cp_orgc_ins_evt_id)
3749: END eventid
3750: FROM HZ_BUS_OBJ_TRACKING t, hz_bes_gt tmp
3751: WHERE t.child_id = tmp.party_id
3752: AND t.child_bo_code = tmp.bo_code
3753: AND t.child_entity_name = 'HZ_PARTIES'
3754: AND t.parent_bo_code IS NULL

Line 3874: FROM HZ_BUS_OBJ_TRACKING t, hz_bes_gt tmp

3870: WHEN 'ORG_CUST' THEN
3871: DECODE ( tmp.event_type_flag, 'U', cp_orgc_upd_evt_id, cp_orgc_ins_evt_id)
3872: END eventid,
3873: NVL(tmp.EVENT_TYPE_FLAG, 'C')
3874: FROM HZ_BUS_OBJ_TRACKING t, hz_bes_gt tmp
3875: WHERE t.child_id = tmp.party_id
3876: AND t.child_bo_code = tmp.bo_code
3877: AND t.child_entity_name = 'HZ_PARTIES'
3878: AND t.parent_bo_code IS NULL

Line 3888: from hz_bes_gt tmp

3884: cp_evt_id IN NUMBER,
3885: cp_rt_node_id IN NUMBER,
3886: cp_bo_code IN VARCHAR2) IS
3887: SELECT NVL(tmp.EVENT_TYPE_FLAG, 'C')
3888: from hz_bes_gt tmp
3889: where tmp.bo_code = cp_bo_code
3890: and tmp.party_id = cp_rt_node_id
3891: and tmp.event_id = cp_evt_id;
3892: */

Line 4061: FROM HZ_BES_GT t

4057: UPDATE HZ_PARTIES
4058: SET PERSON_BO_VERSION = p_per_bo_ver
4059: WHERE party_id IN
4060: (SELECT t.party_id
4061: FROM HZ_BES_GT t
4062: WHERE t.BO_CODE = 'PERSON')
4063: AND (PERSON_BO_VERSION <> p_per_bo_ver
4064: OR PERSON_BO_VERSION IS NULL) ;
4065:

Line 4070: FROM HZ_BES_GT t

4066: UPDATE HZ_PARTIES
4067: SET ORG_BO_VERSION = p_org_bo_ver
4068: WHERE party_id IN
4069: (SELECT t.party_id
4070: FROM HZ_BES_GT t
4071: WHERE t.BO_CODE = 'ORG')
4072: AND (ORG_BO_VERSION <>p_org_bo_ver
4073: OR ORG_BO_VERSION IS NULL);
4074:

Line 4079: FROM HZ_BES_GT t

4075: UPDATE HZ_PARTIES
4076: SET PERSON_CUST_BO_VERSION = p_perc_bo_ver
4077: WHERE party_id IN
4078: (SELECT t.party_id
4079: FROM HZ_BES_GT t
4080: WHERE t.BO_CODE = 'PERSON_CUST')
4081: AND (PERSON_CUST_BO_VERSION <> p_perc_bo_ver
4082: OR PERSON_CUST_BO_VERSION IS NULL);
4083:

Line 4088: FROM HZ_BES_GT t

4084: UPDATE HZ_PARTIES
4085: SET ORG_CUST_BO_VERSION = p_orgc_bo_ver
4086: WHERE party_id IN
4087: (SELECT t.party_id
4088: FROM HZ_BES_GT t
4089: WHERE t.BO_CODE = 'ORG_CUST')
4090: AND (ORG_CUST_BO_VERSION <>p_orgc_bo_ver
4091: OR ORG_CUST_BO_VERSION IS NULL);
4092: