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 3711: FROM dual) pelm,

3707: AND object_type = 'PA_TASKS'
3708: UNION ALL
3709: SELECT 0 source_task_id,
3710: 0 target_task_id
3711: FROM dual) pelm,
3712: pa_resource_list_members prlms,
3713: pa_resource_list_members prlmt
3714: WHERE pra.budget_version_id = p_source_plan_version_id
3715: AND prlms.resource_list_member_id=pra.resource_list_member_id

Line 3984: FROM dual) pelm

3980: AND object_type='PA_TASKS'
3981: UNION ALL
3982: SELECT 0 source_task_id,
3983: 0 target_task_id
3984: FROM dual) pelm
3985: WHERE pra.budget_version_id= p_source_plan_version_id
3986: AND pelm.source_task_id=pra.task_id;
3987:
3988: END IF;--IF l_control_flag ='N' THEN

Line 6056: FROM dual

6052:
6053: /* Code addition for bug 2986930 starts */
6054: CURSOR c_ar_chk( p_source_ver_id pa_budget_versions.budget_version_id%TYPE) IS
6055: SELECT 'Y'
6056: FROM dual
6057: WHERE EXISTS(SELECT NULL
6058: FROM pa_budget_versions
6059: WHERE budget_version_id = p_source_ver_id
6060: AND approved_rev_plan_type_flag = 'Y');

Line 6149: FROM DUAL

6145:
6146: BEGIN
6147: SELECT 'Y'
6148: INTO l_funding_exists_flag
6149: FROM DUAL
6150: WHERE EXISTS (SELECT 1
6151: FROM pa_project_fundings
6152: WHERE project_id = p_target_project_id);
6153: EXCEPTION

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

7814: p_period_type => l_target_time_phased_code,
7815: p_shift_periods => l_periods);
7816:
7817: -- Shift the pa_periods by l_periods
7818: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7819: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7820: -- pa_fp_cpy_periods_tmp
7821:
7822: INSERT INTO PA_BUDGET_LINES(

Line 9586: FROM dual;

9582: l_rate_based_flag := rec_group_source_budget_lines.rate_based_flag;
9583:
9584: SELECT pa_budget_lines_s.nextval
9585: INTO l_target_budget_line_id
9586: FROM dual;
9587:
9588: Open Cur_source_budget_lines(rec_group_source_budget_lines.resource_assignment_id,
9589: rec_group_source_budget_lines.start_date,
9590: l_rate_based_flag,