APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on GL_SETS_OF_BOOKS

Line 770: Gl_Sets_Of_Books sob WHERE

766: BEGIN
767: SELECT TO_CHAR(gl.start_date,'rrrr/mm/dd'),
768: TO_CHAR(gl.end_date,'rrrr/mm/dd') INTO l_start_date,l_end_Date FROM
769: Gl_Periods gl, Pa_Implementations_All imp ,Pa_Projects_All p ,
770: Gl_Sets_Of_Books sob WHERE
771: p.Project_Id = p_project_id AND
772: nvl(p.Org_Id,-99) = NVL(imp.Org_Id,-99) AND
773: imp.Set_Of_Books_Id = sob.Set_Of_Books_Id AND
774: gl.Period_Set_Name = imp.Period_Set_Name AND

Line 1009: Gl_Sets_Of_Books sob WHERE

1005: l_pa_period_type,
1006: l_gl_period_set_name,
1007: l_gl_period_type FROM
1008: Pa_Implementations_All imp ,Pa_Projects_All p ,
1009: Gl_Sets_Of_Books sob WHERE
1010: p.Project_Id = p_project_id AND
1011: nvl(p.Org_Id,-99) = NVL(imp.Org_Id,-99) AND
1012: imp.Set_Of_Books_id = sob.Set_Of_Books_Id;
1013:

Line 1859: FROM Pa_Implementations_All imp, Gl_Sets_Of_Books sob WHERE

1855:
1856: BEGIN
1857: SELECT imp.Period_Set_Name,imp.Pa_Period_Type,sob.Accounted_Period_Type
1858: INTO l_period_set_name , l_pa_period_type,l_gl_period_type
1859: FROM Pa_Implementations_All imp, Gl_Sets_Of_Books sob WHERE
1860: --NVL(imp.Org_Id,-99) = l_prj_org_id AND
1861: imp.Org_Id = l_prj_org_id AND -- Bug Ref # 6327662
1862: imp.Set_Of_Books_Id = sob.Set_Of_Books_Id;
1863: EXCEPTION