eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on FND_LOOKUPS

Line 154: fnd_lookups lookup1,

150: enrl_req.Requestor_resource_id,
151: enrl_req.partner_id
152: FROM pv_pg_enrl_requests enrl_req,
153: pv_partner_program_vl prog,
154: fnd_lookups lookup1,
155: fnd_lookups lookup2
156: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
157: AND enrl_req.program_id = prog.program_id
158: AND lookup1.lookup_type='PV_PROGRAM_PMNT_UNIT'

Line 155: fnd_lookups lookup2

151: enrl_req.partner_id
152: FROM pv_pg_enrl_requests enrl_req,
153: pv_partner_program_vl prog,
154: fnd_lookups lookup1,
155: fnd_lookups lookup2
156: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
157: AND enrl_req.program_id = prog.program_id
158: AND lookup1.lookup_type='PV_PROGRAM_PMNT_UNIT'
159: AND lookup1.lookup_code = prog.membership_period_unit

Line 408: fnd_lookups lookup

404: lookup.meaning
405: FROM pv_pg_memberships membership,
406: pv_pg_enrl_requests enrl_req,
407: pv_partner_program_vl program,
408: fnd_lookups lookup
409: WHERE membership.membership_id = cv_membership_id
410: AND enrl_req.enrl_request_id = membership.enrl_request_id
411: AND membership.program_id = program.program_id
412: AND lookup.lookup_type='PV_ENROLLMENT_REQUEST_TYPE'

Line 614: FROM FND_LOOKUPS

610: RETURN VARCHAR2
611: IS
612: CURSOR c_notification IS
613: SELECT meaning
614: FROM FND_LOOKUPS
615: WHERE lookup_type= 'PV_NOTIFICATION_TYPE'
616: AND lookup_code= p_notif_code;
617:
618: l_notification_name VARCHAR2(80):= NULL;

Line 874: , fnd_lookups lookup1

870: , memb.ORIGINAL_END_DATE
871: , memb.membership_id
872: FROM pv_pg_enrl_requests enrl_req
873: , pv_partner_program_vl prog
874: , fnd_lookups lookup1
875: , fnd_lookups lookup2
876: , pv_pg_memberships memb
877: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
878: AND enrl_req.program_id = prog.program_id

Line 875: , fnd_lookups lookup2

871: , memb.membership_id
872: FROM pv_pg_enrl_requests enrl_req
873: , pv_partner_program_vl prog
874: , fnd_lookups lookup1
875: , fnd_lookups lookup2
876: , pv_pg_memberships memb
877: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
878: AND enrl_req.program_id = prog.program_id
879: AND lookup1.lookup_type='PV_PROGRAM_PMNT_UNIT'