DBA Data[Home] [Help]

APPS.EAM_METERS_UTIL dependencies on EAM_SUPPRESSION_RELATIONS

Line 329: from eam_suppression_relations sup

325: p_meter_id in number,
326: p_meter_reading in number) IS
327: cursor C is
328: select sup.child_association_id
329: from eam_suppression_relations sup
330: where sup.parent_association_id = p_activity_assoc_id;
331:
332:
333: x_child_aa number;

Line 713: from eam_suppression_relations sup

709: p_end_date in date) IS
710:
711: cursor C is
712: select sup.child_association_id
713: from eam_suppression_relations sup
714: where sup.parent_association_id = p_activity_assoc_id;
715:
716: cursor pm_schedule(activity_assoc_id NUMBER,l_default VARCHAR2) is
717: select rescheduling_point

Line 919: eam_suppression_relations sup

915: cursor C is
916: select epac.activity_association_id
917: from eam_pm_activities epac,
918: eam_pm_schedulings eps,
919: eam_suppression_relations sup
920: where sup.parent_association_id = p_activity_assoc_id
921: and sup.child_association_id = epac.activity_association_id
922: and eps.pm_schedule_id = epac.pm_schedule_id
923: and nvl(eps.from_effective_date, sysdate-1) < sysdate

Line 975: eam_suppression_relations sup

971: select epac.pm_schedule_id
972: from eam_pm_activities epac,
973: eam_pm_schedulings eps,
974: eam_pm_activities epap,
975: eam_suppression_relations sup
976: where epap.activity_association_id = sup.parent_association_id
977: and epap.pm_schedule_id = p_parent_pm_id
978: and sup.child_association_id = epac.activity_association_id
979: and eps.pm_schedule_id = epac.pm_schedule_id