DBA Data[Home] [Help]

APPS.XTR_FPS2_P dependencies on XTR_ONE_STEP_SETTLE_CODES

Line 1123: v_settlement_code Xtr_One_Step_Settle_Codes.Settlement_Code%Type;

1119: v_limit_error Boolean;
1120:
1121: v_exp_rec Xtr_Exposure_Transactions%Rowtype;
1122: v_cparty Xtr_Tax_Brokerage_Setup_V.Payee%Type;
1123: v_settlement_code Xtr_One_Step_Settle_Codes.Settlement_Code%Type;
1124: v_amount_hce Xtr_Exposure_Transactions.Amount_HCE%Type;
1125: v_comments Xtr_Exposure_Transactions.Comments%Type;
1126: v_settle_method Xtr_Tax_Brokerage_Setup.Tax_Settle_Method%Type;
1127: v_party_type Xtr_Parties_V.Party_Type%Type;

Line 1164: From XTR_ONE_STEP_SETTLE_CODES_V

1160: settlement code defined during setup is obtained here. if not found, then error out *****/
1161: Begin
1162: Select settlement_code
1163: Into v_settlement_code
1164: From XTR_ONE_STEP_SETTLE_CODES_V
1165: Where company_code = p_one_step_rec.p_company_code
1166: And schedule = p_one_step_rec.p_schedule_code;
1167: Exception
1168: When NO_DATA_FOUND then

Line 1184: From XTR_ONE_STEP_SETTLE_CODES_V

1180: get settlement code which has no schedule defined ****/
1181: Begin
1182: Select settlement_code
1183: Into v_settlement_code
1184: From XTR_ONE_STEP_SETTLE_CODES_V
1185: Where company_code = p_one_step_rec.p_company_code
1186: And schedule is null;
1187: Exception
1188: When NO_DATA_FOUND then