DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on GL_SETS_OF_BOOKS

Line 35: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE

31: ,x_end_date_active OUT NOCOPY date
32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
33: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
34: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
35: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
36: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
39: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE

Line 146: from gl_sets_of_books sob

142: select nvl(p_org_id, imp.org_id)
143: ,sob.currency_code
144: into g_ou_id
145: ,g_func_curr
146: from gl_sets_of_books sob
147: ,pa_implementations imp
148: where imp.set_of_books_id = sob.set_of_books_id and
149: imp.org_id = nvl(l_curr_org_id, imp.org_id); /* Reverted the fix of 7191479 for bug 7365397 */
150: /* nvl(p_org_id, imp.org_id); /* Added the condition for bug 6908073 */