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 716: from eam_suppression_relations sup

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

Line 923: eam_suppression_relations sup

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

Line 979: eam_suppression_relations sup

975: select epac.pm_schedule_id
976: from eam_pm_activities epac,
977: eam_pm_schedulings eps,
978: eam_pm_activities epap,
979: eam_suppression_relations sup
980: where epap.activity_association_id = sup.parent_association_id
981: and epap.pm_schedule_id = p_parent_pm_id
982: and sup.child_association_id = epac.activity_association_id
983: and eps.pm_schedule_id = epac.pm_schedule_id