DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_FP_BUDGET_LINE_REJECTIONS_V

Line 291: FROM pa_fp_budget_line_rejections_v bl

287: ,NVL(bl.revenue_rejection_flag,'N')
288: ,NVL(bl.pc_conv_rejection_flag,'N')
289: ,NVL(bl.pfc_conv_rejection_flag,'N')
290: ,NVL(bl.other_rejection_flag,'N')
291: FROM pa_fp_budget_line_rejections_v bl
292: WHERE bl.budget_version_id = p_budget_version_id
293: AND bl.resource_assignment_id = p_resource_assignment_id
294: AND bl.txn_currency_code = p_txn_currency_code
295: AND (bl.cost_rejection_code is NOT NULL

Line 310: FROM pa_fp_budget_line_rejections_v bl

306: ,NVL(bl.period_revenue_rejection_flag,'N')
307: ,NVL(bl.period_pc_conv_rejection_flag,'N')
308: ,NVL(bl.period_pfc_conv_rejection_flag,'N')
309: ,NVL(bl.period_other_rejection_flag,'N')
310: FROM pa_fp_budget_line_rejections_v bl
311: WHERE bl.budget_version_id = p_budget_version_id
312: AND bl.resource_assignment_id = p_resource_assignment_id
313: AND bl.txn_currency_code = p_txn_currency_code
314: AND bl.start_date between trunc(p_start_date) AND trunc(p_end_date)

Line 448: FROM pa_fp_budget_line_rejections_v bl

444: ,decode(bl.pfc_cur_conv_rejection_code,NULL,NULL,
445: bl.period_name||':'||(substr(bl.pfc_conv_rejection_msg_data,instr(bl.pfc_conv_rejection_msg_data,';',-1)+1)))
446: ,decode(bl.other_rejection_code,NULL,NULL,
447: bl.period_name||':'||(substr(bl.other_rejection_msg_data,instr(bl.other_rejection_msg_data,';',-1)+1)))
448: FROM pa_fp_budget_line_rejections_v bl
449: WHERE bl.budget_version_id = p_budget_version_id
450: AND bl.resource_assignment_id = p_resource_assignment_id
451: AND bl.txn_currency_code = p_txn_currency_code
452: AND bl.start_date BETWEEN trunc(p_start_date) AND trunc(p_end_date)

Line 792: FROM pa_fp_budget_line_rejections_v bl

788: msg1.message_text||':'||bl.project_id||'; '||msg2.message_text||':'||bl.task_id||'; '
789: ||msg3.message_text||':'||bl.resource_list_member_name||'; '||msg4.message_text||':'
790: ||bl.txn_currency_code||'; '||msg5.message_text||':'||bl.start_date||'; '
791: ||(substr(bl.other_rejection_msg_data,instr(bl.other_rejection_msg_data,';',-1)+1)))
792: FROM pa_fp_budget_line_rejections_v bl
793: ,fnd_new_messages msg1
794: ,fnd_new_messages msg2
795: ,fnd_new_messages msg3
796: ,fnd_new_messages msg4