APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 1881: FROM HZ_CUST_ACCT_RELATE

1877: x_object_version_number OUT NOCOPY NUMBER
1878: ) IS
1879: CURSOR is_cust_acct_relate_exist(l_ca_id NUMBER, l_rca_id NUMBER) IS
1880: SELECT nvl(object_version_number,1)
1881: FROM HZ_CUST_ACCT_RELATE
1882: WHERE cust_account_id = l_ca_id
1883: AND related_cust_account_id = l_rca_id
1884: AND status in ('A','I')
1885: AND rownum = 1;

Line 3753: -- HZ_BANK_ACCOUNT_USE, HZ_PAYMENT_METHOD, HZ_CUST_ACCT_RELATE

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

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

3755: p_bus_object.user_mandated_flag(i) = 'Y' AND
3756: p_bus_object.business_object_code(i) = 'CUST_ACCT' AND
3757: p_bus_object.child_bo_code(i) IS NULL) THEN
3758: CASE
3759: WHEN(p_bus_object.entity_name(i) = 'HZ_CUST_ACCT_RELATE_ALL') THEN
3760: l_carel := TRUE;
3761: WHEN(p_bus_object.entity_name(i) = 'RA_CUST_RECEIPT_METHODS') THEN
3762: l_pm := TRUE;
3763: WHEN(p_bus_object.entity_name(i) = 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V') THEN

Line 4506: -- HZ_BANK_ACCOUNT_USE, HZ_PAYMENT_METHOD, HZ_CUST_ACCT_RELATE

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

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

4508: p_bus_object.user_mandated_flag(i) = 'Y' AND
4509: p_bus_object.business_object_code(i) = 'CUST_ACCT' AND
4510: p_bus_object.child_bo_code(i) IS NULL) THEN
4511: CASE
4512: WHEN(p_bus_object.entity_name(i) = 'HZ_CUST_ACCT_RELATE_ALL') THEN
4513: l_carel := TRUE;
4514: WHEN(p_bus_object.entity_name(i) = 'RA_CUST_RECEIPT_METHODS') THEN
4515: l_pm := TRUE;
4516: WHEN(p_bus_object.entity_name(i) = 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V') THEN