APPS.PA_PROGRESS_UTILS dependencies on PA_IMPLEMENTATIONS

Line 3000: SELECT org_id from pa_implementations;

2996: --bug 3828542
2997: l_status VARCHAR2(30);
2998:
2999: CURSOR ou_exp_org_id IS
3000: SELECT org_id from pa_implementations;
3001:
3002: -- Bug 4372462 : written new cursor proj_all
3003: --CURSOR proj_all IS
3004: --SELECT project_currency_code, projfunc_currency_code

Line 3066: ,pa_implementations_all pia

3062: 'COST',ppfo.cost_time_phased_code,
3063: 'REVENUE',ppfo.revenue_time_phased_code,
3064: ppfo.all_time_phased_code) time_phase_code
3065: FROM gl_sets_of_books gsb
3066: ,pa_implementations_all pia
3067: ,pa_projects_all ppa
3068: ,pa_budget_versions pbv
3069: ,pa_proj_fp_options ppfo
3070: WHERE ppa.project_id = pbv.project_id

Line 5928: l_Org_ID pa_implementations_all.org_id%TYPE;

5924: , p_org_id IN NUMBER :=null -- 4746476
5925: )
5926: RETURN VARCHAR2
5927: IS
5928: l_Org_ID pa_implementations_all.org_id%TYPE;
5929: l_Period_Name varchar2(100);
5930: BEGIN
5931: -- 4746476 : Added IF
5932: IF p_org_id IS NULL THEN

Line 5933: SELECT org_id INTO l_Org_ID FROM PA_Implementations;

5929: l_Period_Name varchar2(100);
5930: BEGIN
5931: -- 4746476 : Added IF
5932: IF p_org_id IS NULL THEN
5933: SELECT org_id INTO l_Org_ID FROM PA_Implementations;
5934: ELSE
5935: l_Org_ID := p_org_id;
5936: END IF;
5937:

Line 5949: l_Org_ID pa_implementations_all.org_id%TYPE;

5945: , p_org_id IN NUMBER :=null -- 4746476
5946: )
5947: RETURN VARCHAR2
5948: IS
5949: l_Org_ID pa_implementations_all.org_id%TYPE;
5950: l_Period_Name varchar2(100);
5951: BEGIN
5952: -- 4746476 : Added IF
5953: IF p_org_id IS NULL THEN

Line 5954: SELECT org_id INTO l_Org_ID FROM PA_Implementations;

5950: l_Period_Name varchar2(100);
5951: BEGIN
5952: -- 4746476 : Added IF
5953: IF p_org_id IS NULL THEN
5954: SELECT org_id INTO l_Org_ID FROM PA_Implementations;
5955: ELSE
5956: l_Org_ID := p_org_id;
5957: END IF;
5958:

Line 13066: pa_implementations_all pia,

13062: IF l_cal_type = 'G' THEN
13063: SELECT ftcn.calendar_id INTO l_cal_id
13064: FROM PA_time_cal_name ftcn, /* Modified for bug 12979524 */
13065: pa_projects_all ppa,
13066: pa_implementations_all pia,
13067: gl_sets_of_books gsb
13068: WHERE ppa.project_id=p_project_id
13069: AND ppa.org_id=pia.org_id
13070: AND pia.set_of_books_id=gsb.set_of_books_id

Line 13077: pa_implementations_all pia

13073: ELSIF l_cal_type = 'P' THEN
13074: SELECT ftcn.calendar_id INTO l_cal_id
13075: FROM pa_time_cal_name ftcn, /* Modified for bug 12979524 */
13076: pa_projects_all ppa,
13077: pa_implementations_all pia
13078: WHERE ppa.project_id=p_project_id
13079: AND ppa.org_id=pia.org_id
13080: AND pia.period_set_name=ftcn.period_set_name
13081: AND pia.pa_period_type=ftcn.period_type;