DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_BATCH_RULES

Line 119: --| OKS_BATCH_RULES | X | | | | | |

115: --| CS_COUNTER_GROUPS | X | | | | | |
116: --+---------------------------------+---+---+---+---+---+----------------------+
117: --| CS_INCIDENTS_ALL_B | X | | | | | |
118: --+---------------------------------+---+---+---+---+---+----------------------+
119: --| OKS_BATCH_RULES | X | | | | | |
120: --+---------------------------------+---+---+---+---+---+----------------------+
121: --| CSI_MASS_EDIT_ENTRIES_TL | X | | | | | |
122: --+---------------------------------+---+---+---+---+---+----------------------+
123: --| OKS_INSTANCE_HISTORY | X | X | | | | |

Line 6472: FROM oks_batch_rules

6468: CURSOR get_batch_rules_trm_csr
6469: IS
6470: SELECT credit_option,
6471: nvl(termination_reason_code,'EXP')
6472: FROM oks_batch_rules
6473: WHERE batch_id = p_batch_id;
6474:
6475: CURSOR get_batch_rules_csr
6476: IS

Line 6500: FROM oks_batch_rules a,

6496: NVL(a.new_account_id,p_new_acct_id) new_customer_id,
6497: c.party_id new_party_id,
6498: d.party_name party_name,
6499: a.batch_id batch_id
6500: FROM oks_batch_rules a,
6501: oks_billing_profiles_b b,
6502: hz_cust_accounts c,
6503: hz_parties d
6504: WHERE a.batch_id = p_batch_id

Line 6568: FROM oks_batch_rules

6564: p_batch_id NUMBER
6565: )
6566: IS
6567: SELECT 'x'
6568: FROM oks_batch_rules
6569: WHERE batch_id = p_batch_id;
6570:
6571:
6572: