APPS.AME_MULTI_TENANCY_PKG dependencies on AME_APPROVAL_GROUP_CONFIG

Line 635: from ame_approval_group_config

631: l_start_date date;
632: l_end_date date;
633: cursor chkGrpConfig(c_ent_grp_id in number) is
634: select count(*)
635: from ame_approval_group_config
636: where application_id = g_ent_appl_id
637: and approval_Group_id = c_ent_grp_id
638: and sysdate between start_date and nvl(end_Date,sysdate);
639: --

Line 643: from ame_approval_group_config ent

639: --
640: cursor getConfigUpd(c_ent_grp_id in number,c_voting_regime in varchar2,
641: c_order_number number) is
642: select ent.object_version_number
643: from ame_approval_group_config ent
644: where ent.application_id = g_ent_appl_id
645: and ent.approval_Group_id = c_ent_grp_id
646: and (c_voting_regime <> ent.voting_regime
647: or c_order_number <> ent.order_number)

Line 674: update ame_approval_group_config

670: ,p_object_version_number => l_ovn
671: ,p_start_date => l_start_date
672: ,p_end_date => l_end_date
673: );
674: update ame_approval_group_config
675: set created_by = getSeedUser
676: ,last_updated_by = getSeedUser
677: where application_id = g_ent_appl_id
678: and approval_group_id = p_ent_grp_id

Line 695: update ame_approval_group_config

691: ,p_object_version_number => l_ovn
692: ,p_start_date => l_start_date
693: ,p_end_date => l_end_date
694: );
695: update ame_approval_group_config
696: set created_by = getSeedUser
697: ,last_updated_by = getSeedUser
698: where application_id = g_ent_appl_id
699: and approval_group_id = p_ent_grp_id

Line 808: from ame_approval_group_config agc

804: l_proc_name varchar2(100);
805: cursor fetchTxnGroups is
806: select agp.approval_group_id
807: ,agp.name
808: from ame_approval_group_config agc
809: ,ame_approval_Groups agp
810: where agc.application_id = g_seed_appl_id
811: and agc.approval_Group_id = agp.approval_group_id
812: and sysdate between agp.start_date and nvl(agp.end_Date,sysdate)

Line 1353: ,ame_approval_group_config config

1349: ,config.last_updated_by config_last_updated_by
1350: ,groups.creation_date group_creation_date
1351: ,config.creation_date config_creation_date
1352: from ame_approval_Groups groups
1353: ,ame_approval_group_config config
1354: where application_id = g_seed_appl_id
1355: and groups.approval_group_id = config.approval_group_id
1356: and sysdate between groups.start_date and nvl(groups.end_Date,sysdate)
1357: and sysdate between config.start_date and nvl(config.end_Date,sysdate);