APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_ST_LEVEL_ORG_ASSCNS

Line 1590: from msd_st_level_org_asscns

1586: level_id,
1587: sr_level_pk,
1588: org_level_id,
1589: org_sr_level_pk
1590: from msd_st_level_org_asscns
1591: where instance = p_instance_id
1592: and level_id = p_lvl_id;
1593:
1594:

Line 1619: delete from msd_st_level_org_asscns

1615: /* Refresh the existing Org Calendar relationships for this instance */
1616:
1617: if (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1618:
1619: delete from msd_st_level_org_asscns
1620: where instance = p_instance_id
1621: and level_id = p_lvl_id;
1622:
1623: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';

Line 1623: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';

1619: delete from msd_st_level_org_asscns
1620: where instance = p_instance_id
1621: and level_id = p_lvl_id;
1622:
1623: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';
1624: /* Bug # 3745624. Delete all level org asscns only when Complete Refresh = 'y' else delete only those values which
1625: exist in msd_st_level_org_asscns */
1626: elsif (p_delete_flag = 'Y') then
1627:

Line 1625: exist in msd_st_level_org_asscns */

1621: and level_id = p_lvl_id;
1622:
1623: v_dest_table := 'MSD_ST_LEVEL_ORG_ASSCNS';
1624: /* Bug # 3745624. Delete all level org asscns only when Complete Refresh = 'y' else delete only those values which
1625: exist in msd_st_level_org_asscns */
1626: elsif (p_delete_flag = 'Y') then
1627:
1628: delete from msd_level_org_asscns
1629: where instance = p_instance_id

Line 1683: from msd_st_level_org_asscns

1679: level_id,
1680: sr_level_pk,
1681: org_level_id,
1682: org_sr_level_pk
1683: from msd_st_level_org_asscns
1684: where instance = p_instance_id
1685: and level_id = p_lvl_id) a;
1686:
1687: delete from msd_st_level_org_asscns

Line 1687: delete from msd_st_level_org_asscns

1683: from msd_st_level_org_asscns
1684: where instance = p_instance_id
1685: and level_id = p_lvl_id) a;
1686:
1687: delete from msd_st_level_org_asscns
1688: where instance = p_instance_id
1689: and level_id = p_lvl_id;
1690:
1691: else