APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CUST_PROFILE_AMTS

Line 1830: FROM HZ_CUST_PROFILE_AMTS

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

Line 1836: FROM HZ_CUST_PROFILE_AMTS

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

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

3634: ELSIF(p_bus_object.child_bo_code(i) = 'CUST_PROFILE' AND
3635: p_bus_object.business_object_code(i) = 'CUST_ACCT_SITE_USE' AND
3636: p_bus_object.user_mandated_flag(i) = 'Y') THEN
3637: l_cp := TRUE;
3638: ELSIF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS' AND
3639: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
3640: p_bus_object.user_mandated_flag(i) = 'Y') THEN
3641: l_cpa := TRUE;
3642: END IF;

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

3782: END CASE;
3783: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND
3784: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
3785: p_bus_object.user_mandated_flag(i) = 'Y') THEN
3786: IF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS') THEN
3787: l_cpa := TRUE;
3788: END IF;
3789: END IF;
3790: END LOOP;

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

4386: ELSIF(p_bus_object.child_bo_code(i) = 'CUST_PROFILE' AND
4387: p_bus_object.business_object_code(i) = 'CUST_ACCT_SITE_USE' AND
4388: p_bus_object.user_mandated_flag(i) = 'Y') THEN
4389: l_cp := TRUE;
4390: ELSIF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS' AND
4391: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
4392: p_bus_object.user_mandated_flag(i) = 'Y') THEN
4393: l_cpa := TRUE;
4394: END IF;

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

4535: END CASE;
4536: ELSIF(p_bus_object.child_bo_code(i) IS NOT NULL AND
4537: p_bus_object.business_object_code(i) = 'CUST_PROFILE' AND
4538: p_bus_object.user_mandated_flag(i) = 'Y') THEN
4539: IF(p_bus_object.entity_name(i) = 'HZ_CUST_PROFILE_AMTS') THEN
4540: l_cpa := TRUE;
4541: END IF;
4542: END IF;
4543: END LOOP;