[Home] [Help]
930: nvl(end_date - ame_util.oneSecond,l_effective_date);
931: --+
932: cursor getReqAttributes is
933: select man.attribute_id
934: from ame_mandatory_attributes man
935: ,ame_action_usages acu
936: ,ame_actions act
937: where man.action_type_id = act.action_type_id
938: and acu.action_id = act.action_id
1846: --+
1847: cursor getReqAttributes(p_application_id in integer
1848: ,p_action_type_id in integer) is
1849: select attribute_id
1850: from ame_mandatory_attributes ama
1851: where ama.attribute_id not in (select attribute_id
1852: from ame_attribute_usages
1853: where application_id = p_application_id
1854: and l_effective_date between start_date
1859: --+
1860: cursor getReqAttributeIds(actionIdIn in integer
1861: ,ruleIdIn in integer) is
1862: select man.attribute_id
1863: from ame_mandatory_attributes man
1864: ,ame_action_usages acu
1865: ,ame_actions act
1866: where man.action_type_id = act.action_type_id
1867: and acu.action_id = act.action_id
2765: and nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date);
2766: --+
2767: cursor getReqAttributes is
2768: select man.attribute_id
2769: from ame_mandatory_attributes man
2770: ,ame_action_usages acu
2771: ,ame_actions act
2772: where man.action_type_id = act.action_type_id
2773: and acu.action_id = act.action_id
3379: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
3380: --+
3381: cursor getReqAttributeIds(actionIdIn in integer) is
3382: select man.attribute_id
3383: from ame_mandatory_attributes man
3384: ,ame_actions act
3385: where man.action_type_id = act.action_type_id
3386: and act.action_id = actionIdIn
3387: and l_effective_date between man.start_date and nvl(man.end_date - ame_util.oneSecond, l_effective_date)