DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE_BALANCES dependencies on PER_PEOPLE_F

Line 26: ,permit_type per_people_f.per_information6%type -- action_information21

22: ,cdac_wheld number -- action_information10
23: ,ecf_wheld number -- action_information11
24: ,cpf_ord_earn number -- action_information12
25: ,cpf_addl_earn number -- action_information13
26: ,permit_type per_people_f.per_information6%type -- action_information21
27: ) ;
28:
29: g_cpf_balances t_cpf_balances ;
30: ----------------------------------------------------------------------------

Line 355: p_permit_type per_people_f.per_information6%type) return varchar2

351: p_tax_unit_id in varchar2,
352: p_balance_name in varchar2,
353: p_balance_value in varchar2,
354: p_payroll_action_id in number,
355: p_permit_type per_people_f.per_information6%type) return varchar2
356: is
357: ----------------------------------------------------------------
358: -- For existing employees
359: -- NOTE: order by statement for above query should not be changed