DBA Data[Home] [Help]

APPS.BEN_DM_DATA_UTIL dependencies on HR_DM_PHASE_RULES

Line 1692: from hr_dm_phase_rules

1688: )is
1689:
1690: cursor c1 is
1691: select 'x'
1692: from hr_dm_phase_rules
1693: where p_MIGRATION_TYPE = MIGRATION_TYPE
1694: and p_PHASE_NAME = PHASE_NAME
1695: and p_PREVIOUS_PHASE = PREVIOUS_PHASE
1696: and p_NEXT_PHASE = NEXT_PHASE

Line 1709: insert into hr_dm_phase_rules

1705:
1706: open c1 ;
1707: fetch c1 into l_dummy ;
1708: if c1%notfound then
1709: insert into hr_dm_phase_rules
1710: ( phase_rule_id
1711: ,MIGRATION_TYPE
1712: ,PHASE_NAME
1713: ,PREVIOUS_PHASE

Line 1723: ( hr_dm_phase_rules_s.nextval

1719: ,CREATED_BY
1720: ,CREATION_DATE
1721: ,SECURITY_GROUP_ID
1722: ) Values
1723: ( hr_dm_phase_rules_s.nextval
1724: ,p_MIGRATION_TYPE
1725: ,p_PHASE_NAME
1726: ,p_PREVIOUS_PHASE
1727: ,p_NEXT_PHASE