DBA Data[Home] [Help]

APPS.OZF_CHARGEBACK_PVT dependencies on OZF_SYS_PARAMETERS

Line 156: FROM ozf_sys_parameters;

152: l_order_num_tbl order_num_tbl_type;
153:
154: CURSOR auto_tp_accrual_csr IS
155: SELECT auto_tp_accrual_flag
156: FROM ozf_sys_parameters;
157:
158: CURSOR claimed_amount_csr(p_claim_id IN NUMBER) IS
159: SELECT amount
160: FROM ozf_claims

Line 166: -- FROM ozf_sys_parameters_all;

162:
163: CURSOR end_cust_relation_flag_csr IS
164: SELECT end_cust_relation_flag
165: -- BUG 4992408 (+)
166: -- FROM ozf_sys_parameters_all;
167: FROM ozf_sys_parameters;
168: -- BUG 4992408 (-)
169:
170: l_end_cust_relation_flag VARCHAR2(30);

Line 167: FROM ozf_sys_parameters;

163: CURSOR end_cust_relation_flag_csr IS
164: SELECT end_cust_relation_flag
165: -- BUG 4992408 (+)
166: -- FROM ozf_sys_parameters_all;
167: FROM ozf_sys_parameters;
168: -- BUG 4992408 (-)
169:
170: l_end_cust_relation_flag VARCHAR2(30);
171: l_new_party_rec OZF_RESALE_COMMON_PVT.party_rec_type;

Line 1147: ozf_sys_parameters osp

1143:
1144: CURSOR func_currency_cd_csr IS
1145: SELECT gs.currency_code
1146: FROM gl_sets_of_books gs,
1147: ozf_sys_parameters osp
1148: WHERE gs.set_of_books_id = osp.set_of_books_id
1149: AND osp.org_id = MO_GLOBAL.get_current_org_id();
1150:
1151: CURSOR open_lines_csr(p_order_number VARCHAR2,