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 347: p_permit_type per_people_f.per_information6%type) return varchar2

343: p_tax_unit_id in varchar2,
344: p_balance_name in varchar2,
345: p_balance_value in varchar2,
346: p_payroll_action_id in number,
347: p_permit_type per_people_f.per_information6%type) return varchar2
348: is
349: ----------------------------------------------------------------
350: -- For existing employees
351: -- NOTE: order by statement for above query should not be changed