APPS.PA_CC_TRANSFER_PRICE dependencies on PA_CC_TP_SCHEDULE_LINES

Line 2698: from pa_cc_tp_schedule_lines

2694: Decode(p_labor_non_labor_flag,'Y',labor_percentage_applied,
2695: nl_percentage_applied) percentage_applied
2696: ,start_date_active
2697: ,end_date_active
2698: from pa_cc_tp_schedule_lines
2699: where tp_schedule_id = p_tp_schedule_id
2700: and prvdr_organization_id = l_prvdr_organization_id
2701: and recvr_organization_id = l_recvr_organization_id
2702: and decode( nvl(tp_amt_type_code,'COST_REVENUE'),

Line 2724: from pa_cc_tp_schedule_lines a,

2720: Decode(p_labor_non_labor_flag,'Y',a.labor_percentage_applied,
2721: a.nl_percentage_applied) percentage_applied,
2722: a.start_date_active,
2723: a.end_date_active
2724: from pa_cc_tp_schedule_lines a,
2725: pa_org_hierarchy_denorm b,
2726: pa_org_hierarchy_denorm c
2727: where a.tp_schedule_id = p_tp_schedule_id
2728: and a.PRVDR_ORGANIZATION_ID = b.PARENT_ORGANIZATION_ID

Line 2758: from pa_cc_tp_schedule_lines a,

2754: Decode(p_labor_non_labor_flag,'Y',labor_percentage_applied,
2755: nl_percentage_applied) percentage_applied
2756: ,start_date_active
2757: ,end_date_active
2758: from pa_cc_tp_schedule_lines a,
2759: pa_org_hierarchy_denorm b
2760: where a.tp_schedule_id = p_tp_schedule_id
2761: and a.PRVDR_ORGANIZATION_ID = b.PARENT_ORGANIZATION_ID
2762: and b.CHILD_ORGANIZATION_ID = l_prvdr_organization_id

Line 2793: from pa_cc_tp_schedule_lines a,

2789: Decode(p_labor_non_labor_flag,'Y',a.labor_percentage_applied,
2790: a.nl_percentage_applied) percentage_applied
2791: ,a.start_date_active
2792: ,a.end_date_active
2793: from pa_cc_tp_schedule_lines a,
2794: pa_org_hierarchy_denorm b
2795: where a.tp_schedule_id = p_tp_schedule_id
2796: and a.PRVDR_ORGANIZATION_ID = b.PARENT_ORGANIZATION_ID
2797: and b.CHILD_ORGANIZATION_ID = l_prvdr_organization_id

Line 2821: from pa_cc_tp_schedule_lines

2817: Decode(p_labor_non_labor_flag,'Y',labor_percentage_applied,
2818: nl_percentage_applied) percentage_applied
2819: ,start_date_active
2820: ,end_date_active
2821: from pa_cc_tp_schedule_lines
2822: where tp_schedule_id = p_tp_schedule_id
2823: and default_flag ='Y'
2824: and ((p_labor_non_labor_flag='Y' and labor_tp_rule_id is not null)
2825: OR (p_labor_non_labor_flag='N' and nl_tp_rule_id is not null))

Line 3379: from pa_cc_tp_schedule_lines

3375: is
3376: select
3377: Decode (p_labor_flag ,'Y', labor_tp_rule_id,nl_tp_rule_id ),
3378: Decode (p_labor_flag,'Y',labor_percentage_applied,nl_percentage_applied)
3379: from pa_cc_tp_schedule_lines
3380: where tp_schedule_line_id = p_tp_schedule_line_id;
3381:
3382: BEGIN
3383: pa_debug.Set_err_stack ('Get_Schedule_Line_Attributes');