APPS.PA_PROGRESS_UTILS dependencies on PA_IMPLEMENTATIONS_ALL

Line 3041: ,pa_implementations_all pia

3037: 'COST',ppfo.cost_time_phased_code,
3038: 'REVENUE',ppfo.revenue_time_phased_code,
3039: ppfo.all_time_phased_code) time_phase_code
3040: FROM gl_sets_of_books gsb
3041: ,pa_implementations_all pia
3042: ,pa_projects_all ppa
3043: ,pa_budget_versions pbv
3044: ,pa_proj_fp_options ppfo
3045: WHERE ppa.project_id = pbv.project_id

Line 5893: l_Org_ID pa_implementations_all.org_id%TYPE;

5889: , p_org_id IN NUMBER :=null -- 4746476
5890: )
5891: RETURN VARCHAR2
5892: IS
5893: l_Org_ID pa_implementations_all.org_id%TYPE;
5894: l_Period_Name varchar2(100);
5895: BEGIN
5896: -- 4746476 : Added IF
5897: IF p_org_id IS NULL THEN

Line 5914: l_Org_ID pa_implementations_all.org_id%TYPE;

5910: , p_org_id IN NUMBER :=null -- 4746476
5911: )
5912: RETURN VARCHAR2
5913: IS
5914: l_Org_ID pa_implementations_all.org_id%TYPE;
5915: l_Period_Name varchar2(100);
5916: BEGIN
5917: -- 4746476 : Added IF
5918: IF p_org_id IS NULL THEN

Line 12969: pa_implementations_all pia,

12965: IF l_cal_type = 'G' THEN
12966: SELECT ftcn.calendar_id INTO l_cal_id
12967: FROM fii_time_cal_name ftcn,
12968: pa_projects_all ppa,
12969: pa_implementations_all pia,
12970: gl_sets_of_books gsb
12971: WHERE ppa.project_id=p_project_id
12972: AND ppa.org_id=pia.org_id
12973: AND pia.set_of_books_id=gsb.set_of_books_id

Line 12980: pa_implementations_all pia

12976: ELSIF l_cal_type = 'P' THEN
12977: SELECT ftcn.calendar_id INTO l_cal_id
12978: FROM fii_time_cal_name ftcn,
12979: pa_projects_all ppa,
12980: pa_implementations_all pia
12981: WHERE ppa.project_id=p_project_id
12982: AND ppa.org_id=pia.org_id
12983: AND pia.period_set_name=ftcn.period_set_name
12984: AND pia.pa_period_type=ftcn.period_type;