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_CC_TRANSFER_PRICE dependencies on PA_CC_TP_SCHEDULE_LINES

Line 2602: from pa_cc_tp_schedule_lines

2598: Decode(p_labor_non_labor_flag,'Y',labor_percentage_applied,
2599: nl_percentage_applied) percentage_applied
2600: ,start_date_active
2601: ,end_date_active
2602: from pa_cc_tp_schedule_lines
2603: where tp_schedule_id = p_tp_schedule_id
2604: and prvdr_organization_id = l_prvdr_organization_id
2605: and recvr_organization_id = l_recvr_organization_id
2606: and decode( nvl(tp_amt_type_code,'COST_REVENUE'),

Line 2628: from pa_cc_tp_schedule_lines a,

2624: Decode(p_labor_non_labor_flag,'Y',a.labor_percentage_applied,
2625: a.nl_percentage_applied) percentage_applied,
2626: a.start_date_active,
2627: a.end_date_active
2628: from pa_cc_tp_schedule_lines a,
2629: pa_org_hierarchy_denorm b,
2630: pa_org_hierarchy_denorm c
2631: where a.tp_schedule_id = p_tp_schedule_id
2632: and a.PRVDR_ORGANIZATION_ID = b.PARENT_ORGANIZATION_ID

Line 2662: from pa_cc_tp_schedule_lines a,

2658: Decode(p_labor_non_labor_flag,'Y',labor_percentage_applied,
2659: nl_percentage_applied) percentage_applied
2660: ,start_date_active
2661: ,end_date_active
2662: from pa_cc_tp_schedule_lines a,
2663: pa_org_hierarchy_denorm b
2664: where a.tp_schedule_id = p_tp_schedule_id
2665: and a.PRVDR_ORGANIZATION_ID = b.PARENT_ORGANIZATION_ID
2666: and b.CHILD_ORGANIZATION_ID = l_prvdr_organization_id

Line 2697: from pa_cc_tp_schedule_lines a,

2693: Decode(p_labor_non_labor_flag,'Y',a.labor_percentage_applied,
2694: a.nl_percentage_applied) percentage_applied
2695: ,a.start_date_active
2696: ,a.end_date_active
2697: from pa_cc_tp_schedule_lines a,
2698: pa_org_hierarchy_denorm b
2699: where a.tp_schedule_id = p_tp_schedule_id
2700: and a.PRVDR_ORGANIZATION_ID = b.PARENT_ORGANIZATION_ID
2701: and b.CHILD_ORGANIZATION_ID = l_prvdr_organization_id

Line 2725: from pa_cc_tp_schedule_lines

2721: Decode(p_labor_non_labor_flag,'Y',labor_percentage_applied,
2722: nl_percentage_applied) percentage_applied
2723: ,start_date_active
2724: ,end_date_active
2725: from pa_cc_tp_schedule_lines
2726: where tp_schedule_id = p_tp_schedule_id
2727: and default_flag ='Y'
2728: and ((p_labor_non_labor_flag='Y' and labor_tp_rule_id is not null)
2729: OR (p_labor_non_labor_flag='N' and nl_tp_rule_id is not null))

Line 3283: from pa_cc_tp_schedule_lines

3279: is
3280: select
3281: Decode (p_labor_flag ,'Y', labor_tp_rule_id,nl_tp_rule_id ),
3282: Decode (p_labor_flag,'Y',labor_percentage_applied,nl_percentage_applied)
3283: from pa_cc_tp_schedule_lines
3284: where tp_schedule_line_id = p_tp_schedule_line_id;
3285:
3286: BEGIN
3287: pa_debug.Set_err_stack ('Get_Schedule_Line_Attributes');