APPS.XTR_LIMITS_P dependencies on XTR_COMPANY_LIMITS

Line 123: from XTR_COMPANY_LIMITS

119: where party_code = pc_party_code;
120: --
121: cursor c_get_limit_type (pc_limit_code VARCHAR2,pc_comp_code VARCHAR2) is
122: select upper(limit_type)
123: from XTR_COMPANY_LIMITS
124: where limit_code = pc_limit_code
125: and company_code = pc_comp_code;
126: --
127: cursor get_home_ccy is

Line 969: from XTR_company_limits

965: -- mirror row is inserted/updated.
966: --
967: cursor c_get_type is
968: select limit_type
969: from XTR_company_limits
970: where company_code = p_new_company_code
971: and limit_code = p_new_limit_code;
972: --
973: cursor c_get_country (pc_party_code VARCHAR2) is

Line 1179: FROM xtr_company_limits

1175: p_err_code OUT NOCOPY VARCHAR2) is
1176: --
1177: cursor c_get_util(pc1_company_code VARCHAR2,pc1_limit_code VARCHAR2) is
1178: SELECT nvl(limit_amount,0), nvl(utilised_amount,0)
1179: FROM xtr_company_limits
1180: WHERE company_code = pc1_company_code
1181: AND limit_code = pc1_limit_code
1182: AND (limit_amount <> 0 OR utilised_amount <> 0);
1183: --

Line 1826: update xtr_COMPANY_LIMITS_V

1822: retcode OUT NOCOPY NUMBER) IS
1823: BEGIN
1824: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;
1825: --
1826: update xtr_COMPANY_LIMITS_V
1827: set UTILISED_AMOUNT = 0;
1828: update xtr_COUNTERPARTY_LIMITS_V
1829: set UTILISED_AMOUNT = 0;
1830: update xtr_MASTER_CURRENCIES