APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 1885: FROM HZ_CUST_ACCT_RELATE

1881: x_object_version_number OUT NOCOPY NUMBER
1882: ) IS
1883: CURSOR is_cust_acct_relate_exist(l_ca_id NUMBER, l_rca_id NUMBER) IS
1884: SELECT nvl(object_version_number,1)
1885: FROM HZ_CUST_ACCT_RELATE
1886: WHERE cust_account_id = l_ca_id
1887: AND related_cust_account_id = l_rca_id
1888: AND status in ('A','I')
1889: AND ORG_ID = NVL(p_org_id, ORG_ID) -- bug 8549266

Line 3758: -- HZ_BANK_ACCOUNT_USE, HZ_PAYMENT_METHOD, HZ_CUST_ACCT_RELATE

3754: END IF;
3755:
3756: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3757: -- get all entities of cust acct, for cust acct, the possible entites are
3758: -- HZ_BANK_ACCOUNT_USE, HZ_PAYMENT_METHOD, HZ_CUST_ACCT_RELATE
3759: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3760: p_bus_object.user_mandated_flag(i) = 'Y' AND
3761: p_bus_object.business_object_code(i) = 'CUST_ACCT' AND
3762: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 3764: WHEN(p_bus_object.entity_name(i) = 'HZ_CUST_ACCT_RELATE_ALL') THEN

3760: p_bus_object.user_mandated_flag(i) = 'Y' AND
3761: p_bus_object.business_object_code(i) = 'CUST_ACCT' AND
3762: p_bus_object.child_bo_code(i) IS NULL) THEN
3763: CASE
3764: WHEN(p_bus_object.entity_name(i) = 'HZ_CUST_ACCT_RELATE_ALL') THEN
3765: l_carel := TRUE;
3766: WHEN(p_bus_object.entity_name(i) = 'RA_CUST_RECEIPT_METHODS') THEN
3767: l_pm := TRUE;
3768: WHEN(p_bus_object.entity_name(i) = 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V') THEN

Line 4511: -- HZ_BANK_ACCOUNT_USE, HZ_PAYMENT_METHOD, HZ_CUST_ACCT_RELATE

4507: END IF;
4508:
4509: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
4510: -- get all entities of cust acct, for cust acct, the possible entites are
4511: -- HZ_BANK_ACCOUNT_USE, HZ_PAYMENT_METHOD, HZ_CUST_ACCT_RELATE
4512: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
4513: p_bus_object.user_mandated_flag(i) = 'Y' AND
4514: p_bus_object.business_object_code(i) = 'CUST_ACCT' AND
4515: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 4517: WHEN(p_bus_object.entity_name(i) = 'HZ_CUST_ACCT_RELATE_ALL') THEN

4513: p_bus_object.user_mandated_flag(i) = 'Y' AND
4514: p_bus_object.business_object_code(i) = 'CUST_ACCT' AND
4515: p_bus_object.child_bo_code(i) IS NULL) THEN
4516: CASE
4517: WHEN(p_bus_object.entity_name(i) = 'HZ_CUST_ACCT_RELATE_ALL') THEN
4518: l_carel := TRUE;
4519: WHEN(p_bus_object.entity_name(i) = 'RA_CUST_RECEIPT_METHODS') THEN
4520: l_pm := TRUE;
4521: WHEN(p_bus_object.entity_name(i) = 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V') THEN