APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_PROFILE_AMTS

Line 1827: FROM HZ_CUST_PROFILE_AMTS

1823: x_object_version_number OUT NOCOPY NUMBER
1824: ) IS
1825: CURSOR is_cust_profile_amt_id_exist(l_cust_prof_amt_id NUMBER) IS
1826: SELECT nvl(object_version_number,1), cust_account_profile_id
1827: FROM HZ_CUST_PROFILE_AMTS
1828: WHERE cust_acct_profile_amt_id = l_cust_prof_amt_id
1829: AND rownum = 1;
1830:
1831: CURSOR is_cust_profile_amt_exist(l_cap_id NUMBER, l_currency_code VARCHAR2) IS

Line 1833: FROM HZ_CUST_PROFILE_AMTS

1829: AND rownum = 1;
1830:
1831: CURSOR is_cust_profile_amt_exist(l_cap_id NUMBER, l_currency_code VARCHAR2) IS
1832: SELECT nvl(object_version_number,1), cust_acct_profile_amt_id
1833: FROM HZ_CUST_PROFILE_AMTS
1834: WHERE cust_account_profile_id = l_cap_id
1835: AND currency_code = l_currency_code
1836: AND rownum = 1;
1837:

Line 3633: ELSIF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS' AND

3629: ELSIF(p_bus_object.child_bo_code(i) = 'CUST_PROFILE' AND
3630: p_bus_object.business_object_code(i) = 'CUST_ACCT_SITE_USE' AND
3631: p_bus_object.user_mandated_flag(i) = 'Y') THEN
3632: l_cp := TRUE;
3633: ELSIF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS' AND
3634: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
3635: p_bus_object.user_mandated_flag(i) = 'Y') THEN
3636: l_cpa := TRUE;
3637: END IF;

Line 3781: IF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS') THEN

3777: END CASE;
3778: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND
3779: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
3780: p_bus_object.user_mandated_flag(i) = 'Y') THEN
3781: IF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS') THEN
3782: l_cpa := TRUE;
3783: END IF;
3784: END IF;
3785: END LOOP;

Line 4385: ELSIF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS' AND

4381: ELSIF(p_bus_object.child_bo_code(i) = 'CUST_PROFILE' AND
4382: p_bus_object.business_object_code(i) = 'CUST_ACCT_SITE_USE' AND
4383: p_bus_object.user_mandated_flag(i) = 'Y') THEN
4384: l_cp := TRUE;
4385: ELSIF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS' AND
4386: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
4387: p_bus_object.user_mandated_flag(i) = 'Y') THEN
4388: l_cpa := TRUE;
4389: END IF;

Line 4534: IF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS') THEN

4530: END CASE;
4531: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND
4532: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
4533: p_bus_object.user_mandated_flag(i) = 'Y') THEN
4534: IF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS') THEN
4535: l_cpa := TRUE;
4536: END IF;
4537: END IF;
4538: END LOOP;