APPS.IGS_EN_WORKFLOW dependencies on HZ_PARTIES

Line 1574: FROM hz_parties

1570:
1571: -- Cursor to fetch the person number
1572: CURSOR cur_pers_number(cp_person_id NUMBER) IS
1573: SELECT party_number
1574: FROM hz_parties
1575: WHERE party_id = cp_person_id;
1576:
1577: l_cur_prof_value cur_prof_value%ROWTYPE;
1578: l_cur_pers_number cur_pers_number%ROWTYPE;

Line 1796: FROM hz_parties

1792: FROM DUAL;
1793:
1794: CURSOR c_person_dtls (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1795: SELECT party_number,party_name
1796: FROM hz_parties
1797: WHERE party_id = cp_person_id;
1798:
1799: l_person_number hz_parties.party_number%TYPE;
1800: l_person_name hz_parties.party_name%TYPE;

Line 1799: l_person_number hz_parties.party_number%TYPE;

1795: SELECT party_number,party_name
1796: FROM hz_parties
1797: WHERE party_id = cp_person_id;
1798:
1799: l_person_number hz_parties.party_number%TYPE;
1800: l_person_name hz_parties.party_name%TYPE;
1801: l_user_name fnd_user.user_name%TYPE;
1802:
1803: l_cur_seq_val cur_seq_val%ROWTYPE;

Line 1800: l_person_name hz_parties.party_name%TYPE;

1796: FROM hz_parties
1797: WHERE party_id = cp_person_id;
1798:
1799: l_person_number hz_parties.party_number%TYPE;
1800: l_person_name hz_parties.party_name%TYPE;
1801: l_user_name fnd_user.user_name%TYPE;
1802:
1803: l_cur_seq_val cur_seq_val%ROWTYPE;
1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();