1032: p_action_information3=>rg_get_person_details.person_id ,
1033: p_action_information4=>l_Employee_name ,
1034: p_action_information5=> rg_get_person_details.national_identifier ,
1035: p_action_information6=> '3' ,
1036: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension) ,
1037: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension) ,
1038: p_action_information9=> FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension) ,
1039: p_action_information10=> g_payroll_action_id,
1040: p_action_information11=> NULL,
1033: p_action_information4=>l_Employee_name ,
1034: p_action_information5=> rg_get_person_details.national_identifier ,
1035: p_action_information6=> '3' ,
1036: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension) ,
1037: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension) ,
1038: p_action_information9=> FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension) ,
1039: p_action_information10=> g_payroll_action_id,
1040: p_action_information11=> NULL,
1041: p_action_information12=> NULL ,
1034: p_action_information5=> rg_get_person_details.national_identifier ,
1035: p_action_information6=> '3' ,
1036: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_pension) ,
1037: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_bik_subject_pension) ,
1038: p_action_information9=> FND_NUMBER.NUMBER_TO_CANONICAL(l_tax_exp_subject_pension) ,
1039: p_action_information10=> g_payroll_action_id,
1040: p_action_information11=> NULL,
1041: p_action_information12=> NULL ,
1042: p_action_information13=> NULL,
1085:
1086: /*
1087: CURSOR csr_person_pay_action_info(p_payroll_action_id pay_action_information.action_information1%TYPE)
1088: IS
1089: SELECT COUNT(*) emp_count , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information7) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information8) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information9)) emp_sal
1090: ,sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information11)) pension , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information12)) emp_pension
1091: FROM pay_action_information
1092: WHERE action_information_category = 'EMEA REPORT INFORMATION'
1093: AND action_information1 = 'PYFILTFA'
1086: /*
1087: CURSOR csr_person_pay_action_info(p_payroll_action_id pay_action_information.action_information1%TYPE)
1088: IS
1089: SELECT COUNT(*) emp_count , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information7) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information8) + FND_NUMBER.CANONICAL_TO_NUMBER(action_information9)) emp_sal
1090: ,sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information11)) pension , sum (FND_NUMBER.CANONICAL_TO_NUMBER(action_information12)) emp_pension
1091: FROM pay_action_information
1092: WHERE action_information_category = 'EMEA REPORT INFORMATION'
1093: AND action_information1 = 'PYFILTFA'
1094: AND action_information2 = 'PER'
1170: p_action_information1=> 'PYFILTFA',
1171: p_action_information2=> g_emp_type,
1172: p_action_information3=>'S' ,
1173: p_action_information4=> l_emp_count ,
1174: p_action_information5=> FND_NUMBER.NUMBER_TO_CANONICAL(l_emp_sal) ,
1175: p_action_information6=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total_ins_fee) ,
1176: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL((nvl(g_penalty_amt,0))*100) ,
1177: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total) ,
1178: p_action_information9=> NULL ,
1171: p_action_information2=> g_emp_type,
1172: p_action_information3=>'S' ,
1173: p_action_information4=> l_emp_count ,
1174: p_action_information5=> FND_NUMBER.NUMBER_TO_CANONICAL(l_emp_sal) ,
1175: p_action_information6=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total_ins_fee) ,
1176: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL((nvl(g_penalty_amt,0))*100) ,
1177: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total) ,
1178: p_action_information9=> NULL ,
1179: p_action_information10=> p_payroll_action_id,
1172: p_action_information3=>'S' ,
1173: p_action_information4=> l_emp_count ,
1174: p_action_information5=> FND_NUMBER.NUMBER_TO_CANONICAL(l_emp_sal) ,
1175: p_action_information6=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total_ins_fee) ,
1176: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL((nvl(g_penalty_amt,0))*100) ,
1177: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total) ,
1178: p_action_information9=> NULL ,
1179: p_action_information10=> p_payroll_action_id,
1180: p_action_information11=> NULL,
1173: p_action_information4=> l_emp_count ,
1174: p_action_information5=> FND_NUMBER.NUMBER_TO_CANONICAL(l_emp_sal) ,
1175: p_action_information6=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total_ins_fee) ,
1176: p_action_information7=> FND_NUMBER.NUMBER_TO_CANONICAL((nvl(g_penalty_amt,0))*100) ,
1177: p_action_information8=> FND_NUMBER.NUMBER_TO_CANONICAL(l_total) ,
1178: p_action_information9=> NULL ,
1179: p_action_information10=> p_payroll_action_id,
1180: p_action_information11=> NULL,
1181: p_action_information12=> NULL,