APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_ST_LEVEL_ORG_ASSCNS

Line 1622: from msd_st_level_org_asscns

1618: level_id,
1619: sr_level_pk,
1620: org_level_id,
1621: org_sr_level_pk
1622: from msd_st_level_org_asscns
1623: where instance = p_instance_id
1624: and level_id = p_lvl_id;
1625:
1626:

Line 1651: delete from msd_st_level_org_asscns

1647: /* Refresh the existing Org Calendar relationships for this instance */
1648:
1649: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1650:
1651: delete from msd_st_level_org_asscns
1652: where instance = p_instance_id
1653: and level_id = p_lvl_id;
1654:
1655: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';

Line 1655: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';

1651: delete from msd_st_level_org_asscns
1652: where instance = p_instance_id
1653: and level_id = p_lvl_id;
1654:
1655: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';
1656: /* Bug # 3745624. Delete all level org asscns only when Complete Refresh = 'y' else delete only those values which
1657: exist in msd_st_level_org_asscns */
1658: elsif (p_delete_flag = 'Y') then
1659:

Line 1657: exist in msd_st_level_org_asscns */

1653: and level_id = p_lvl_id;
1654:
1655: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';
1656: /* Bug # 3745624. Delete all level org asscns only when Complete Refresh = 'y' else delete only those values which
1657: exist in msd_st_level_org_asscns */
1658: elsif (p_delete_flag = 'Y') then
1659:
1660: delete from msd_level_org_asscns
1661: where instance = p_instance_id

Line 1715: from msd_st_level_org_asscns

1711: level_id,
1712: sr_level_pk,
1713: org_level_id,
1714: org_sr_level_pk
1715: from msd_st_level_org_asscns
1716: where instance = p_instance_id
1717: and level_id = p_lvl_id) a;
1718:
1719: delete from msd_st_level_org_asscns

Line 1719: delete from msd_st_level_org_asscns

1715: from msd_st_level_org_asscns
1716: where instance = p_instance_id
1717: and level_id = p_lvl_id) a;
1718:
1719: delete from msd_st_level_org_asscns
1720: where instance = p_instance_id
1721: and level_id = p_lvl_id;
1722:
1723: else