APPS.HR_PRE_PAY dependencies on HR_LOOKUPS

Line 85: -- from hr_lookups hlu,

81: opm.currency_code payment_currency,
82: ppt.pre_validation_required validation_required,
83: ppt.validation_value validation_value,
84: opm.external_account_id external_account_id
85: -- from hr_lookups hlu,
86: from pay_external_accounts pea,
87: pay_payment_types ppt,
88: pay_org_payment_methods_f opm,
89: pay_personal_payment_methods_f ppm

Line 143: cash_rule hr_lookups.description%type;

139: g_pre_payments pre_pay_tab;
140: --
141: function set_cash_rule(p_type in varchar2, p_seg1 in varchar2)
142: return varchar2 is
143: cash_rule hr_lookups.description%type;
144: begin
145: if (p_type = 'CA') then
146: select hlu.description
147: into cash_rule

Line 148: from hr_lookups hlu

144: begin
145: if (p_type = 'CA') then
146: select hlu.description
147: into cash_rule
148: from hr_lookups hlu
149: where p_seg1 = hlu.lookup_code
150: and hlu.lookup_type = 'CASH_ANALYSIS'
151: and NVL(hlu.application_id, 800) = 800 ;
152: --