APPS.XTR_LIMITS_P dependencies on XTR_PARTY_INFO

Line 118: from XTR_PARTY_INFO

114: -- Do ALL the "limits" checks and log any errors to the log table.
115: --
116: cursor c_get_country_group (pc_party_code VARCHAR2) is
117: select upper(country_code),upper(nvl(cross_ref_to_other_party,pc_party_code))
118: from XTR_PARTY_INFO
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)

Line 187: v_country_code XTR_PARTY_INFO.country_code%TYPE;

183: v_company_code VARCHAR2(7);
184: v_limit_amt NUMBER;
185: v_util_amt NUMBER;
186: v_err_code VARCHAR2(8);
187: v_country_code XTR_PARTY_INFO.country_code%TYPE;
188: v_group_party VARCHAR2(7);
189: v_time_limit NUMBER;
190: --
191: v_hce_amount NUMBER;

Line 832: from XTR_PARTY_INFO

828: (DEAL_TYPE IN('ONC','CMF') and PRODUCT_TYPE <> 'FIXED'));
829: --
830: cursor c_get_country (pc_party_code VARCHAR2) is
831: select country_code
832: from XTR_PARTY_INFO
833: where party_code = pc_party_code;
834: --
835: cursor HCE is
836: select amount,rowid row_id,DEAL_TYPE,DEAL_SUBTYPE,AMOUNT_DATE,COMPANY_CODE,CURRENCY

Line 975: from XTR_PARTY_INFO

971: and limit_code = p_new_limit_code;
972: --
973: cursor c_get_country (pc_party_code VARCHAR2) is
974: select country_code,nvl(cross_ref_to_other_party,pc_party_code)
975: from XTR_PARTY_INFO
976: where party_code = pc_party_code;
977: --
978: v_country_code XTR_PARTY_INFO.country_code%TYPE;
979: v_utilised_amount NUMBER;

Line 978: v_country_code XTR_PARTY_INFO.country_code%TYPE;

974: select country_code,nvl(cross_ref_to_other_party,pc_party_code)
975: from XTR_PARTY_INFO
976: where party_code = pc_party_code;
977: --
978: v_country_code XTR_PARTY_INFO.country_code%TYPE;
979: v_utilised_amount NUMBER;
980: v_hce_utilised_amt NUMBER;
981: v_hce_amt NUMBER;
982: v_limit_party VARCHAR2(7);