153: pay_assignment_actions paa,
154: pay_pre_payments ppp,
155: pay_org_payment_methods_f_tl popmftl,
156: pay_org_payment_methods_f popmf,
157: pay_payment_types_tl ppttl,
158: pay_payment_types ppt,
159: pay_external_accounts pea,
160: per_time_periods ptp
161: WHERE ppt.payment_type_id = ppttl.payment_type_id
154: pay_pre_payments ppp,
155: pay_org_payment_methods_f_tl popmftl,
156: pay_org_payment_methods_f popmf,
157: pay_payment_types_tl ppttl,
158: pay_payment_types ppt,
159: pay_external_accounts pea,
160: per_time_periods ptp
161: WHERE ppt.payment_type_id = ppttl.payment_type_id
162: AND ppttl.LANGUAGE = USERENV ('LANG')
296: );
297:
298:
299: --
300: l_pymt_type pay_payment_types_tl.payment_type_name%TYPE;
301: l_master_rec VARCHAR2 (1);
302: BEGIN
303: hr_utility.set_location ('Input Parameters', 01);
304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);