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_BENFT_STATUS_CHANGE dependencies on PV_REFERRALS_B

Line 457: from pv_referrals_b ref, pv_ge_benefits_b ben

453:
454: cursor lc_get_entity_detail (pc_entity_id number) is
455: select ref.referral_code, ben.benefit_type_code, ref.entity_type, ref.entity_id_linked_to,
456: ref.decline_reason_code, ref.order_id
457: from pv_referrals_b ref, pv_ge_benefits_b ben
458: where ref.referral_id = pc_entity_id and ref.benefit_id = ben.benefit_id;
459:
460: cursor lc_oppty_linked_flag (pc_lead_id number) is
461: select lead_number, prm_referral_code from as_leads_all where lead_id = pc_lead_id;

Line 468: select referral_code from pv_referrals_b where referral_id = pc_referral_id;

464: select lead_number, decode(source_system,'REFERRAL',source_primary_reference,NULL)
465: from as_sales_leads where sales_lead_id = pc_lead_id;
466:
467: cursor lc_ref_linked_flag (pc_referral_id number) is
468: select referral_code from pv_referrals_b where referral_id = pc_referral_id;
469:
470: cursor lc_event_reason IS
471: select decline_reason_code from pv_referrals_b
472: where referral_id = P_ENTITY_ID;

Line 471: select decline_reason_code from pv_referrals_b

467: cursor lc_ref_linked_flag (pc_referral_id number) is
468: select referral_code from pv_referrals_b where referral_id = pc_referral_id;
469:
470: cursor lc_event_reason IS
471: select decline_reason_code from pv_referrals_b
472: where referral_id = P_ENTITY_ID;
473:
474: cursor lc_current_approvers(pc_benefit_type varchar2, pc_referral_id number) is
475: select apr.approver_id, jrre.source_name

Line 965: FROM pv_referrals_b REF

961: l_referral_status_code varchar2(25);
962:
963: CURSOR c_ref_details IS
964: SELECT REF.benefit_id, REF.referral_id, REF.partner_id
965: FROM pv_referrals_b REF
966: WHERE REF.claim_id = l_claim_id;
967:
968: BEGIN
969:

Line 1068: UPDATE pv_referrals_b

1064:
1065: -- ----------------------------------------------------------------
1066: -- Update Referral Status
1067: -- ----------------------------------------------------------------
1068: UPDATE pv_referrals_b
1069: SET referral_status = l_referral_status_code
1070: WHERE referral_id = l_referral_id;
1071:
1072:

Line 1520: select partner_id from pv_referrals_b where referral_id = pc_entity_id;

1516: and jtfd.jtf_auth_domain_id=jtfpm.jtf_auth_domain_id
1517: and jtfd.domain_name='CRM_DOMAIN';
1518:
1519: cursor lc_get_partner_id(pc_entity_id number) is
1520: select partner_id from pv_referrals_b where referral_id = pc_entity_id;
1521:
1522: cursor lc_get_pt_cont(pc_entity_id number) is
1523: select fnd.user_name
1524: from fnd_user fnd, pv_referrals_b ref, jtf_rs_resource_extns jtf

Line 1524: from fnd_user fnd, pv_referrals_b ref, jtf_rs_resource_extns jtf

1520: select partner_id from pv_referrals_b where referral_id = pc_entity_id;
1521:
1522: cursor lc_get_pt_cont(pc_entity_id number) is
1523: select fnd.user_name
1524: from fnd_user fnd, pv_referrals_b ref, jtf_rs_resource_extns jtf
1525: where ref.partner_contact_resource_id = jtf.resource_id
1526: and jtf.user_id = fnd.user_id
1527: and ref.referral_id = pc_entity_id;
1528:

Line 1531: from as_sales_leads a, pv_referrals_b b, jtf_rs_resource_extns c

1527: and ref.referral_id = pc_entity_id;
1528:
1529: cursor lc_get_lead_owner (pc_entity_id number) is
1530: select c.user_name
1531: from as_sales_leads a, pv_referrals_b b, jtf_rs_resource_extns c
1532: where b.referral_id = pc_entity_id
1533: and b.entity_id_linked_to = a.sales_lead_id
1534: and a.assign_to_salesforce_id = c.resource_id;
1535:

Line 1538: from as_accesses_all a, pv_referrals_b b, jtf_rs_resource_extns c

1534: and a.assign_to_salesforce_id = c.resource_id;
1535:
1536: cursor lc_get_oppty_slsteam (pc_entity_id number) is
1537: select c.user_name
1538: from as_accesses_all a, pv_referrals_b b, jtf_rs_resource_extns c
1539: where b.referral_id = pc_entity_id
1540: and b.entity_id_linked_to = a.lead_id
1541: and a.salesforce_id = c.resource_id
1542: and c.category = 'EMPLOYEE';

Line 1901: select b.meaning from pv_referrals_b a, FND_LOOKUP_VALUES_VL b

1897: document in out nocopy varchar2,
1898: document_type in out nocopy varchar2) IS
1899:
1900: cursor lc_get_reason (pc_entity_id number) is
1901: select b.meaning from pv_referrals_b a, FND_LOOKUP_VALUES_VL b
1902: where a.referral_id = pc_entity_id
1903: and a.decline_reason_code = b.lookup_code
1904: and b.lookup_type = 'PV_REFERRAL_DECLINE_REASON';
1905:

Line 1943: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c

1939: document_type in out nocopy varchar2) IS
1940:
1941: cursor lc_get_products (pc_entity_id number) is
1942: select c.CONCAT_CAT_PARENTAGE, b.amount || ' ' || a.currency_code amount
1943: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c
1944: where a.referral_id = pc_entity_id
1945: and a.referral_id = b.referral_id
1946: and b.product_category_set_id = c.category_set_id
1947: and b.product_category_id = c.category_id;

Line 1951: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c

1947: and b.product_category_id = c.category_id;
1948:
1949: cursor lc_max_products_length (pc_entity_id number) is
1950: select max(length(c.CONCAT_CAT_PARENTAGE)), max(length(to_char(b.amount) || ' ' || a.currency_code))
1951: from pv_referrals_b a, pv_referred_products b, eni_prod_den_hrchy_parents_v c
1952: where a.referral_id = pc_entity_id
1953: and a.referral_id = b.referral_id
1954: and b.product_category_set_id = c.category_set_id
1955: and b.product_category_id = c.category_id;