DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_IMPLEMENTATIONS

Line 37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%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
40: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE
41: ,x_err_stage OUT NOCOPY number

Line 132: ,pa_implementations imp

128: ,sob.currency_code
129: into g_ou_id
130: ,g_func_curr
131: from gl_sets_of_books sob
132: ,pa_implementations imp
133: where imp.set_of_books_id = sob.set_of_books_id and
134: imp.org_id = l_curr_org_id; /* Reverted the fix of 7191479 for bug 7365397 */
135: /* nvl(p_org_id, imp.org_id); /* Added the condition for bug 6908073 */
136: /* Modified the above select for bug 7191479 */

Line 520: ( p_org_id IN pa_implementations_all.org_id%TYPE

516: raise;
517: end get_labor_rate;
518: ---------------------------------------------------------------------------------------------
519: PROCEDURE get_orgn_level_costing_info
520: ( p_org_id IN pa_implementations_all.org_id%TYPE
521: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
522: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
523: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
524: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

Line 533: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

529: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
530: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
531: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
532: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
533: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
534: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
535: ,x_err_stage IN OUT NOCOPY number
536: ,x_err_code IN OUT NOCOPY varchar2
537: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE

549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
552:
553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
554: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
555: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
556: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
557: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

Line 572: ,pa_implementations imp

568: ,assign.acct_rate_type
569: ,assign.acct_exchange_rate
570: from pa_org_labor_sch_rule assign
571: ,pa_org_hierarchy_denorm hier
572: ,pa_implementations imp
573: where hier.child_organization_id = p_organization_id
574: and imp.exp_org_structure_version_id=hier.org_hierarchy_version_id
575: and hier.pa_org_use_type = 'TP_SCHEDULE'
576: and assign.organization_id = hier.parent_organization_id