APPS.IGF_SE_PAYMENT_PUB dependencies on IGF_SE_AUTH

Line 97: p_auth_id igf_se_auth.auth_id%TYPE,

93:
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

Line 106: CURSOR c_get_fund_id (p_auth_id igf_se_auth.auth_id%TYPE,

102: AND p.auth_id = p_auth_id
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'

Line 109: FROM igf_se_auth se

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
112: AND se.auth_id = p_auth_id;
113: