APPS.PV_BENFT_STATUS_CHANGE dependencies on PV_GE_TEMP_APPROVERS

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 476: from pv_ge_temp_approvers apr, jtf_rs_resource_extns jrre

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
476: from pv_ge_temp_approvers apr, jtf_rs_resource_extns jrre
477: where apr.arc_appr_for_entity_code = pc_benefit_type
478: and apr.appr_for_entity_id = pc_referral_id
479: and apr.approver_id = jrre.user_id
480: and APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT')

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')