APPS.IGS_DA_TRNS_IMP dependencies on FND_USER

Line 2686: FROM igs_da_rqst dr, fnd_user fdu

2682:
2683: CURSOR c_requestor
2684: IS
2685: SELECT dr.requestor_id
2686: FROM igs_da_rqst dr, fnd_user fdu
2687: WHERE dr.batch_id = p_batch_id
2688: AND dr.requestor_id = fdu.person_party_id;
2689:
2690: CURSOR c_adv_stnd_unt (

Line 2717: FROM hz_parties, fnd_user

2713:
2714: CURSOR c_requestor_id
2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:
2721:

Line 2718: WHERE fnd_user.customer_id = hz_parties.party_id

2714: CURSOR c_requestor_id
2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:
2721:
2722:

Line 2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');

2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:
2721:
2722:
2723: l_adv_stnd_unt c_adv_stnd_unt%ROWTYPE;

Line 3342: FROM hz_parties, fnd_user

3338:
3339: CURSOR c_requestor_id
3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;

Line 3343: WHERE fnd_user.customer_id = hz_parties.party_id

3339: CURSOR c_requestor_id
3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;

Line 3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');

3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;