APPS.PA_CC_TRANSFER_PRICE dependencies on PA_ORG_HIERARCHY_DENORM

Line 2629: pa_org_hierarchy_denorm b,

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

Line 2630: pa_org_hierarchy_denorm c

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

Line 2663: pa_org_hierarchy_denorm b

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

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

2681: --DevDrop2 Changes End
2682:
2683:
2684: --DevDrop2 Changes
2685: --Added pa_org_hierarchy_denorm join to the below cursor.
2686:
2687:
2688: cursor c_other_rule(l_prvdr_organization_id NUMBER)
2689: is

Line 2698: pa_org_hierarchy_denorm b

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