APPS.IGF_SE_PAYMENT_PUB dependencies on HZ_PARTIES

Line 98: p_person_id hz_parties.party_id%TYPE) IS

94: -- cursor to check if the existing payroll id, person id and authorization id
95: -- is already existing in the system. this cursor will have FTS ?
96: CURSOR c_check_payroll (p_payroll_id igf_se_payment.payroll_id%TYPE,
97: p_auth_id igf_se_auth.auth_id%TYPE,
98: p_person_id hz_parties.party_id%TYPE) IS
99: SELECT ROWID, p.*
100: FROM igf_se_payment p
101: WHERE p.payroll_id = p_payroll_id
102: AND p.auth_id = p_auth_id

Line 107: p_person_id hz_parties.party_id%TYPE) IS

103: AND p.person_id = p_person_id;
104:
105: -- cursor to get the fund id from the supplied parameters
106: CURSOR c_get_fund_id (p_auth_id igf_se_auth.auth_id%TYPE,
107: p_person_id hz_parties.party_id%TYPE) IS
108: SELECT se.fund_id
109: FROM igf_se_auth se
110: WHERE se.flag = 'A'
111: AND se.person_id = p_person_id

Line 120: cp_person_id hz_parties.party_id%TYPE

116: l_rowid VARCHAR2(25);
117: l_transaction_id igf_se_payment.transaction_id%TYPE;
118:
119: CURSOR c_pers_num(
120: cp_person_id hz_parties.party_id%TYPE
121: ) IS
122: SELECT party_number
123: FROM hz_parties
124: WHERE party_id = cp_person_id;

Line 123: FROM hz_parties

119: CURSOR c_pers_num(
120: cp_person_id hz_parties.party_id%TYPE
121: ) IS
122: SELECT party_number
123: FROM hz_parties
124: WHERE party_id = cp_person_id;
125: l_pers_num hz_parties.party_number%TYPE;
126:
127: BEGIN

Line 125: l_pers_num hz_parties.party_number%TYPE;

121: ) IS
122: SELECT party_number
123: FROM hz_parties
124: WHERE party_id = cp_person_id;
125: l_pers_num hz_parties.party_number%TYPE;
126:
127: BEGIN
128: l_fund_id := NULL;
129: l_transaction_id := NULL;