DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE_BALANCES dependencies on PAY_CORE_UTILS

Line 57: select nvl(pay_core_utils.get_parameter('CPF_INTEREST',legislative_parameters),0)

53: return varchar2
54: is
55: l_cpf_interest varchar2(100);
56: begin
57: select nvl(pay_core_utils.get_parameter('CPF_INTEREST',legislative_parameters),0)
58: into l_cpf_interest
59: from pay_payroll_actions
60: where payroll_action_id = c_payroll_action_id;
61: return l_cpf_interest;

Line 73: select nvl(pay_core_utils.get_parameter('FWL_INTEREST',legislative_parameters),0)

69: return varchar2
70: is
71: l_fwl_interest varchar2(100);
72: begin
73: select nvl(pay_core_utils.get_parameter('FWL_INTEREST',legislative_parameters),0)
74: into l_fwl_interest
75: from pay_payroll_actions
76: where payroll_action_id = c_payroll_action_id;
77: return l_fwl_interest;

Line 123: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',

119: from hr_organization_information hoi,
120: pay_payroll_actions ppa
121: where ppa.payroll_action_id = p_payroll_action_id
122: and hoi.organization_id =
123: to_number(pay_core_utils.get_parameter('LEGAL_ENTITY_ID',
124: ppa.legislative_parameters))
125: and hoi.org_information_context = 'SG_LEGAL_ENTITY';
126: begin
127: l_package := ' pay_sg_cpfline.';