APPS.CST_ACCRUAL_REC_PVT dependencies on CST_ACCRUAL_ACCOUNTS

Line 63: INSERT into cst_accrual_accounts(

59: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'Operating Unit: ' || to_char(p_ou_id));
60:
61: l_stmt_num := 10;
62:
63: INSERT into cst_accrual_accounts(
64: operating_unit_id,
65: accrual_account_id,
66: last_update_date,
67: last_updated_by,

Line 95: from cst_accrual_accounts caa

91: from po_accrual_accounts_temp_all paat
92: where paat.org_id = p_ou_id
93: and not exists (
94: select 1
95: from cst_accrual_accounts caa
96: where caa.accrual_account_id = paat.accrual_account_id
97: and caa.operating_unit_id = p_ou_id)
98: and exists ( select 1
99: from financials_system_params_all fsp,

Line 116: from cst_accrual_accounts caa

112: where psp.accrued_code_combination_id is not null
113: and psp.org_id = p_ou_id
114: and not exists (
115: select 1
116: from cst_accrual_accounts caa
117: where caa.accrual_account_id = psp.accrued_code_combination_id
118: and caa.operating_unit_id = p_ou_id)
119: and exists ( select 1
120: from financials_system_params_all fsp,

Line 142: from cst_accrual_accounts caa

138: and hoi.org_information_context = 'Accounting Information'
139: and hoi.org_information3 = to_char(p_ou_id))
140: and not exists (
141: select 1
142: from cst_accrual_accounts caa
143: where caa.accrual_account_id = mp.ap_accrual_account
144: and caa.operating_unit_id = p_ou_id)
145: and exists ( select 1
146: from financials_system_params_all fsp,