DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 99: from financials_system_params_all fsp,

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,
100: gl_sets_of_books gsb,
101: gl_code_combinations gcc
102: where gsb.set_of_books_id = fsp.set_of_books_id
103: and fsp.org_id = p_ou_id

Line 120: from financials_system_params_all fsp,

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,
121: gl_sets_of_books gsb,
122: gl_code_combinations gcc
123: where gsb.set_of_books_id = fsp.set_of_books_id
124: and fsp.org_id = p_ou_id

Line 146: from financials_system_params_all fsp,

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,
147: gl_sets_of_books gsb,
148: gl_code_combinations gcc
149: where gsb.set_of_books_id = fsp.set_of_books_id
150: and fsp.org_id = p_ou_id

Line 1385: from financials_system_params_all

1381: if(c_wo_rec.l_tot_bal > (l_wo_cr * l_ent_sum)) then
1382: --{
1383: select rate_var_gain_ccid
1384: into l_erv_id
1385: from financials_system_params_all
1386: where org_id = p_ou_id;
1387: --}
1388: else
1389: --{

Line 1392: from financials_system_params_all

1388: else
1389: --{
1390: select rate_var_loss_ccid
1391: into l_erv_id
1392: from financials_system_params_all
1393: where org_id = p_ou_id;
1394: --}
1395: end if; /* c_wo_rec.l_tot_bal > (l_wo_cr + l_ent_sum) */
1396: --}