eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 147: ,pa_implementations imp

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 */
151: /* Modified the above select for bug 7191479 */

Line 636: ( p_org_id IN pa_implementations_all.org_id%TYPE

632: raise;
633: end get_labor_rate;
634: ---------------------------------------------------------------------------------------------
635: PROCEDURE get_orgn_level_costing_info
636: ( p_org_id IN pa_implementations_all.org_id%TYPE
637: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
638: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
639: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
640: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

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

647: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE
649: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
650: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
652: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
653: ,x_err_stage IN OUT NOCOPY number
654: ,x_err_code IN OUT NOCOPY varchar2
655: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE

672: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE;
673: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
674: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
675:
676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE
677: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
678: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
679: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
680: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

Line 697: ,pa_implementations imp

693: ,assign.base_hours
694: ,assign.rbc_element_type_id
695: from pa_org_labor_sch_rule assign
696: ,pa_org_hierarchy_denorm hier
697: ,pa_implementations imp
698: where hier.child_organization_id = p_organization_id
699: and imp.exp_org_structure_version_id=hier.org_hierarchy_version_id
700: and hier.pa_org_use_type = 'TP_SCHEDULE'
701: and assign.organization_id = hier.parent_organization_id

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

703: and trunc(p_txn_date) between trunc(assign.start_date_active)
704: and trunc(nvl(assign.end_date_active,p_txn_date));
705:
706:
707: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
708: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
709: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
710: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
711: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

Line 728: ,pa_implementations imp

724: ,assign.base_hours
725: ,assign.rbc_element_type_id
726: from pa_org_labor_sch_rule assign
727: ,pa_org_hierarchy_denorm hier
728: ,pa_implementations imp
729: where hier.child_organization_id = p_organization_id
730: and imp.exp_org_structure_version_id=hier.org_hierarchy_version_id
731: and hier.pa_org_use_type = 'TP_SCHEDULE'
732: and assign.organization_id = hier.parent_organization_id