APPS.XTR_STOCK_PKG dependencies on XTR_STOCK_CASH_DIVIDENDS

Line 20: From xtr_stock_cash_dividends

16: D CUR_DEAL%ROWTYPE;
17:
18: Cursor cur_div_share is
19: Select cash_dividend_id, dividend_per_share, declare_date
20: From xtr_stock_cash_dividends
21: Where stock_issue_code = D.bond_issue
22: And record_date >= D.start_date
23: And nvl(generated_flag, 'N') IN ('G', 'Y');
24: /* Bug 3737048 Added the new status in the cursor. */

Line 466: from XTR_STOCK_CASH_DIVIDENDS

462: p_payment_date DATE) return BOOLEAN IS
463:
464: cursor EXIST_STOCK_DIV is
465: select 1
466: from XTR_STOCK_CASH_DIVIDENDS
467: where STOCK_ISSUE_CODE = p_stock_issue
468: and DECLARE_DATE = p_declare_date
469: and RECORD_DATE = p_record_date
470: and PAYMENT_DATE = p_payment_date;

Line 508: from XTR_STOCK_CASH_DIVIDENDS

504: p_record_date DATE) return BOOLEAN IS
505:
506: cursor EXIST_STOCK_DIV is
507: select 1
508: from XTR_STOCK_CASH_DIVIDENDS
509: where STOCK_ISSUE_CODE = p_stock_issue
510: and DECLARE_DATE = p_declare_date
511: and RECORD_DATE = p_record_date
512: and cash_dividend_id <> p_cash_dividend_id;