90: l_source_id NUMBER;
91:
92: BEGIN
93:
94: hr_utility.set_location('pay_ca_pmed', 10);
95: IF p_account_number IS NOT NULL AND
96: p_account_number <> 'NOT ENTERED' THEN
97: hr_utility.set_location('pay_ca_pmed', 20);
98: OPEN csr_get_src_id1(p_jurisdiction_code,
93:
94: hr_utility.set_location('pay_ca_pmed', 10);
95: IF p_account_number IS NOT NULL AND
96: p_account_number <> 'NOT ENTERED' THEN
97: hr_utility.set_location('pay_ca_pmed', 20);
98: OPEN csr_get_src_id1(p_jurisdiction_code,
99: p_account_number,p_business_group_id);
100: FETCH csr_get_src_id1 INTO l_source_id;
101: CLOSE csr_get_src_id1;
100: FETCH csr_get_src_id1 INTO l_source_id;
101: CLOSE csr_get_src_id1;
102: ELSIF p_different_jd IS NOT NULL AND
103: p_different_jd <> 'NOT ENTERED' THEN
104: hr_utility.set_location('pay_ca_pmed', 30);
105: OPEN csr_get_src_id2(p_different_jd,
106: p_tax_unit_id,p_business_group_id);
107: FETCH csr_get_src_id2 INTO l_source_id,
108: p_account_number;
107: FETCH csr_get_src_id2 INTO l_source_id,
108: p_account_number;
109: CLOSE csr_get_src_id2;
110: ELSE
111: hr_utility.set_location('pay_ca_pmed', 40);
112: OPEN csr_get_src_id3(p_jurisdiction_code,
113: p_tax_unit_id,p_business_group_id);
114: FETCH csr_get_src_id3 INTO l_source_id,
115: p_account_number;
115: p_account_number;
116: CLOSE csr_get_src_id3;
117: END IF;
118:
119: hr_utility.set_location('pay_ca_pmed', 50);
120: RETURN l_source_id;
121:
122: END;
123: