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 FND_USER

Line 46: select fnd_user.user_name

42: and entity_status = pc_status
43: AND user_role like pc_userrole;
44:
45: cursor lc_get_cm (pc_partner_id number) is
46: select fnd_user.user_name
47: from pv_partner_accesses acc, jtf_rs_resource_extns res, fnd_user
48: where acc.partner_id = pc_partner_id
49: and acc.resource_id = res.resource_id
50: and res.user_id = fnd_user.user_id;

Line 47: from pv_partner_accesses acc, jtf_rs_resource_extns res, fnd_user

43: AND user_role like pc_userrole;
44:
45: cursor lc_get_cm (pc_partner_id number) is
46: select fnd_user.user_name
47: from pv_partner_accesses acc, jtf_rs_resource_extns res, fnd_user
48: where acc.partner_id = pc_partner_id
49: and acc.resource_id = res.resource_id
50: and res.user_id = fnd_user.user_id;
51:

Line 50: and res.user_id = fnd_user.user_id;

46: select fnd_user.user_name
47: from pv_partner_accesses acc, jtf_rs_resource_extns res, fnd_user
48: where acc.partner_id = pc_partner_id
49: and acc.resource_id = res.resource_id
50: and res.user_id = fnd_user.user_id;
51:
52: cursor lc_get_approvers (pc_benefit_type varchar2, pc_entity_id number) is
53: select fnd_user.user_name
54: from pv_ge_temp_approvers apr, fnd_user

Line 53: select fnd_user.user_name

49: and acc.resource_id = res.resource_id
50: and res.user_id = fnd_user.user_id;
51:
52: cursor lc_get_approvers (pc_benefit_type varchar2, pc_entity_id number) is
53: select fnd_user.user_name
54: from pv_ge_temp_approvers apr, fnd_user
55: where apr.arc_appr_for_entity_code = pc_benefit_type
56: and apr.appr_for_entity_id = pc_entity_id
57: and apr.approver_id = fnd_user.user_id

Line 54: from pv_ge_temp_approvers apr, fnd_user

50: and res.user_id = fnd_user.user_id;
51:
52: cursor lc_get_approvers (pc_benefit_type varchar2, pc_entity_id number) is
53: select fnd_user.user_name
54: from pv_ge_temp_approvers apr, fnd_user
55: where apr.arc_appr_for_entity_code = pc_benefit_type
56: and apr.appr_for_entity_id = pc_entity_id
57: and apr.approver_id = fnd_user.user_id
58: AND APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT')

Line 57: and apr.approver_id = fnd_user.user_id

53: select fnd_user.user_name
54: from pv_ge_temp_approvers apr, fnd_user
55: where apr.arc_appr_for_entity_code = pc_benefit_type
56: and apr.appr_for_entity_id = pc_entity_id
57: and apr.approver_id = fnd_user.user_id
58: AND APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT')
59: and apr.approver_type_code = 'USER';
60:
61: l_benefit_type varchar2(8);

Line 1466: fnd_user usr

1462: FROM
1463: pv_partner_profiles prof,
1464: hz_relationships pr2,
1465: jtf_rs_resource_extns pj,
1466: fnd_user usr
1467: WHERE
1468: prof.partner_id = pc_partner_id
1469: and prof.partner_party_id = pr2.object_id
1470: and pr2.subject_table_name = 'HZ_PARTIES'

Line 1503: fnd_user usr

1499: from jtf_auth_principal_maps jtfpm,
1500: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1501: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
1502: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
1503: fnd_user usr
1504: where PJ.user_name = jtfp1.principal_name
1505: and pj.category = 'EMPLOYEE'
1506: and usr.user_id = pj.user_id
1507: and (usr.end_date > sysdate OR usr.end_date IS NULL)

Line 1523: select fnd.user_name

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
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;

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 1526: and jtf.user_id = fnd.user_id

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:
1529: cursor lc_get_lead_owner (pc_entity_id number) is
1530: select c.user_name

Line 1546: select distinct fnd_user.user_name

1542: and c.category = 'EMPLOYEE';
1543:
1544: -- bug 3671420
1545: cursor lc_get_all_approvers (pc_benefit_type varchar2, pc_entity_id number) is
1546: select distinct fnd_user.user_name
1547: from pv_ge_temp_approvers apr, fnd_user
1548: where apr.arc_appr_for_entity_code = pc_benefit_type
1549: and apr.appr_for_entity_id = pc_entity_id
1550: and apr.approver_id = fnd_user.user_id

Line 1547: from pv_ge_temp_approvers apr, fnd_user

1543:
1544: -- bug 3671420
1545: cursor lc_get_all_approvers (pc_benefit_type varchar2, pc_entity_id number) is
1546: select distinct fnd_user.user_name
1547: from pv_ge_temp_approvers apr, fnd_user
1548: where apr.arc_appr_for_entity_code = pc_benefit_type
1549: and apr.appr_for_entity_id = pc_entity_id
1550: and apr.approver_id = fnd_user.user_id
1551: AND APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT','APPROVED')

Line 1550: and apr.approver_id = fnd_user.user_id

1546: select distinct fnd_user.user_name
1547: from pv_ge_temp_approvers apr, fnd_user
1548: where apr.arc_appr_for_entity_code = pc_benefit_type
1549: and apr.appr_for_entity_id = pc_entity_id
1550: and apr.approver_id = fnd_user.user_id
1551: AND APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT','APPROVED')
1552: and apr.approver_type_code = 'USER';
1553:
1554: begin