APPS.PA_CC_TRANSFER_PRICE dependencies on PA_ORG_HIERARCHY_DENORM

Line 2725: pa_org_hierarchy_denorm b,

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
2729: and b.CHILD_ORGANIZATION_ID = l_prvdr_organization_id

Line 2726: pa_org_hierarchy_denorm c

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
2729: and b.CHILD_ORGANIZATION_ID = l_prvdr_organization_id
2730: and a.RECVR_ORGANIZATION_ID = c.PARENT_ORGANIZATION_ID

Line 2759: pa_org_hierarchy_denorm b

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
2763: and b.org_hierarchy_version_id = G_exp_org_struct_ver_id

Line 2781: --Added pa_org_hierarchy_denorm join to the below cursor.

2777: --DevDrop2 Changes End
2778:
2779:
2780: --DevDrop2 Changes
2781: --Added pa_org_hierarchy_denorm join to the below cursor.
2782:
2783:
2784: cursor c_other_rule(l_prvdr_organization_id NUMBER)
2785: is

Line 2794: pa_org_hierarchy_denorm b

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
2798: and a.recvr_organization_id is null