APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_IMPLEMENTATIONS

Line 114: PA_IMPLEMENTATIONS IMP

110: IS
111: SELECT FC.Currency_Code, imp.org_id, imp.exp_start_org_id, imp.exp_org_structure_version_id
112: FROM FND_CURRENCIES FC,
113: GL_SETS_OF_BOOKS GB,
114: PA_IMPLEMENTATIONS IMP
115: WHERE FC.Currency_Code = DECODE(IMP.Set_Of_Books_ID, Null,
116: Null,GB.CURRENCY_CODE)
117: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;
118:

Line 144: from pa_implementations;

140: cursor cur_impl
141: is
142: select adv_action_set_id, multi_currency_billing_flag, default_rate_type
143: ,retn_accounting_flag, competence_match_wt, availability_match_wt, job_level_match_wt
144: from pa_implementations;
145:
146: l_adv_action_set_id NUMBER;
147: l_rate_date_code VARCHAR2(30);
148: l_rate_type VARCHAR2(30);

Line 1860: CURSOR cur_impl IS SELECT default_rate_type FROM pa_implementations;

1856:
1857: CURSOR cur_nl_cur IS SELECT rate_sch_currency_code FROM pa_std_bill_rate_schedules_all
1858: WHERE bill_rate_sch_id = l_non_lab_std_bill_rt_sch_id ;
1859:
1860: CURSOR cur_impl IS SELECT default_rate_type FROM pa_implementations;
1861:
1862: x_job_rate_sch_currency VARCHAR2(30);
1863: x_emp_rate_sch_currency VARCHAR2(30);
1864: x_nl_rate_sch_currency VARCHAR2(30);