APPS.HZP_CPROF_PKG dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 1102: FROM hz_cust_prof_class_amts

1098: jgzz_attribute12,
1099: jgzz_attribute13,
1100: jgzz_attribute14,
1101: jgzz_attribute15
1102: FROM hz_cust_prof_class_amts
1103: WHERE profile_class_id = x_customer_profile_class_id;
1104:
1105: --
1106:

Line 1109: FROM hz_cust_prof_class_amts

1105: --
1106:
1107: CURSOR c_get_profile_amt_id(l_profile_class_id NUMBER, l_currency_code VARCHAR2) IS
1108: SELECT profile_class_amount_id
1109: FROM hz_cust_prof_class_amts
1110: WHERE profile_class_id = l_profile_class_id
1111: AND currency_code = l_currency_code;
1112:
1113: l_profile_class_amount_id NUMBER;

Line 1265: from hz_cust_prof_class_amts

1261: DELETE FROM hz_cust_profile_amts
1262: WHERE cust_account_profile_id =
1263: NVL(old_customer_profile_id,x_customer_profile_id)
1264: AND currency_code in ( select currency_code
1265: from hz_cust_prof_class_amts
1266: where profile_class_id = x_customer_profile_class_id
1267: );
1268: END IF;
1269:

Line 1300: from hz_cust_prof_class_amts

1296: ELSE
1297: DELETE FROM hz_cust_profile_amts
1298: WHERE cust_account_profile_id = x_customer_profile_id
1299: AND currency_code in ( select currency_code
1300: from hz_cust_prof_class_amts
1301: where profile_class_id = x_customer_profile_class_id
1302: );
1303: END IF;
1304: ********** Bug Fix End#3 : 3107081 *************************/

Line 1626: FROM hz_cust_prof_class_amts

1622: jgzz_attribute12,
1623: jgzz_attribute13,
1624: jgzz_attribute14,
1625: jgzz_attribute15
1626: FROM hz_cust_prof_class_amts
1627: WHERE profile_class_id = x_customer_profile_class_id;
1628:
1629: CURSOR c_get_profile_amt_id(l_profile_class_id NUMBER, l_currency_code VARCHAR2) IS
1630: SELECT profile_class_amount_id

Line 1631: FROM hz_cust_prof_class_amts

1627: WHERE profile_class_id = x_customer_profile_class_id;
1628:
1629: CURSOR c_get_profile_amt_id(l_profile_class_id NUMBER, l_currency_code VARCHAR2) IS
1630: SELECT profile_class_amount_id
1631: FROM hz_cust_prof_class_amts
1632: WHERE profile_class_id = l_profile_class_id
1633: AND currency_code = l_currency_code;
1634: l_profile_class_amount_id NUMBER;
1635: l_msg_count NUMBER;

Line 1793: from hz_cust_prof_class_amts

1789: DELETE FROM hz_cust_profile_amts
1790: WHERE cust_account_profile_id =
1791: NVL(old_customer_profile_id,x_customer_profile_id)
1792: AND currency_code in ( select currency_code
1793: from hz_cust_prof_class_amts
1794: where profile_class_id = x_customer_profile_class_id
1795: );
1796: END IF;
1797:

Line 1826: from hz_cust_prof_class_amts

1822: ELSE
1823: DELETE FROM hz_cust_profile_amts
1824: WHERE cust_account_profile_id = x_customer_profile_id
1825: AND currency_code in ( select currency_code
1826: from hz_cust_prof_class_amts
1827: where profile_class_id = x_customer_profile_class_id
1828: );
1829: END IF;
1830: ********** Bug Fix End#6 : 3107081 *************************/