APPS.PA_FP_COPY_FROM_PKG dependencies on DUAL

Line 708: FROM DUAL;

704: ,l_pc_cost_exchange_rate_tbl(i)
705: ,l_pc_rev_exchange_rate_tbl(i)
706: ,l_pfc_cost_exchange_rate_tbl(i)
707: ,l_pfc_rev_exchange_rate_tbl(i)
708: FROM DUAL;
709: END IF;
710: END IF;
711: -- End of changes for bug 2729191
712:

Line 1404: FROM DUAL;

1400: END IF;
1401:
1402: SELECT pa_budget_versions_s.NEXTVAL
1403: INTO px_target_version_id
1404: FROM DUAL;
1405:
1406: -- For workplan context project structure version id should be populated
1407: -- For Finplan the column is not maintained
1408:

Line 3721: FROM dual) pelm,

3717: AND object_type = 'PA_TASKS'
3718: UNION ALL
3719: SELECT 0 source_task_id,
3720: 0 target_task_id
3721: FROM dual) pelm,
3722: pa_resource_list_members prlms,
3723: pa_resource_list_members prlmt
3724: WHERE pra.budget_version_id = p_source_plan_version_id
3725: AND prlms.resource_list_member_id=pra.resource_list_member_id

Line 3996: FROM dual) pelm

3992: AND object_type='PA_TASKS'
3993: UNION ALL
3994: SELECT 0 source_task_id,
3995: 0 target_task_id
3996: FROM dual) pelm
3997: WHERE pra.budget_version_id= p_source_plan_version_id
3998: AND pelm.source_task_id=pra.task_id;
3999:
4000: END IF;--IF l_control_flag ='N' THEN

Line 6069: FROM dual

6065:
6066: /* Code addition for bug 2986930 starts */
6067: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS
6068: SELECT 'Y'
6069: FROM dual
6070: WHERE EXISTS(SELECT NULL
6071: FROM pa_budget_versions
6072: WHERE budget_version_id = p_source_ver_id
6073: AND approved_rev_plan_type_flag = 'Y');

Line 6162: FROM DUAL

6158:
6159: BEGIN
6160: SELECT 'Y'
6161: INTO l_funding_exists_flag
6162: FROM DUAL
6163: WHERE EXISTS (SELECT 1
6164: FROM pa_project_fundings
6165: WHERE project_id = p_target_project_id);
6166: EXCEPTION

Line 7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based

7841: p_period_type => l_target_time_phased_code,
7842: p_shift_periods => l_periods);
7843:
7844: -- Shift the pa_periods by l_periods
7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7846: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7847: -- pa_fp_cpy_periods_tmp
7848:
7849: INSERT INTO PA_BUDGET_LINES(

Line 9613: FROM dual;

9609: l_rate_based_flag := rec_group_source_budget_lines.rate_based_flag;
9610:
9611: SELECT pa_budget_lines_s.nextval
9612: INTO l_target_budget_line_id
9613: FROM dual;
9614:
9615: Open Cur_source_budget_lines(rec_group_source_budget_lines.resource_assignment_id,
9616: rec_group_source_budget_lines.start_date,
9617: l_rate_based_flag,