eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_BALANCE_PKG

Line 215: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer);

211: vCHANGECtr := 1;
212: l_change_count := 0;
213: j := 1;
214: l_n_c := 0 ;
215: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer);
216: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_temp_effective_date));
217: l_defined_balance_id_net_asg := get_def_bal_id('SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');
218: if csr_get_change_emp % ISOPEN then
219: close csr_get_change_emp;

Line 216: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_temp_effective_date));

212: l_change_count := 0;
213: j := 1;
214: l_n_c := 0 ;
215: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer);
216: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_temp_effective_date));
217: l_defined_balance_id_net_asg := get_def_bal_id('SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');
218: if csr_get_change_emp % ISOPEN then
219: close csr_get_change_emp;
220: open csr_get_change_emp(p_employer,l_temp_effective_date,p_nationality);

Line 257: IF l_n_c <> 1 and pay_balance_pkg.get_value(l_defined_balance_id_net_asg,l_cur_asact_id) <> pay_balance_pkg.get_value(l_defined_balance_id_net_asg,l_prev_asact_id) THEN

253: l_prev_asact_id := 0;
254: l_n_c := 1 ;
255: end if;
256: close get_assact_id_tot_prev_month;
257: IF l_n_c <> 1 and pay_balance_pkg.get_value(l_defined_balance_id_net_asg,l_cur_asact_id) <> pay_balance_pkg.get_value(l_defined_balance_id_net_asg,l_prev_asact_id) THEN
258: l_change_count := l_change_count + 1;
259: vCHANGE_FINALTable(j).person_id := vCHANGETable(i).person_id;
260: j := j + 1;
261: END IF;

Line 573: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);

569: OPEN csr_soc_bal_id(p_employer_id);
570: FETCH csr_soc_bal_id into l_soc_bal_id;
571: CLOSE csr_soc_bal_id;
572:
573: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
574: pay_balance_pkg.set_context('DATE_EARNED', p_effective_date);
575: open csr_get_start_date (p_person_id , p_effective_date);
576: fetch csr_get_start_date into l_temp_start_date;
577: close csr_get_start_date;

Line 574: pay_balance_pkg.set_context('DATE_EARNED', p_effective_date);

570: FETCH csr_soc_bal_id into l_soc_bal_id;
571: CLOSE csr_soc_bal_id;
572:
573: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
574: pay_balance_pkg.set_context('DATE_EARNED', p_effective_date);
575: open csr_get_start_date (p_person_id , p_effective_date);
576: fetch csr_get_start_date into l_temp_start_date;
577: close csr_get_start_date;
578: If l_temp_start_date < trunc(p_effective_date,'YYYY') then

Line 587: l_test_cont_sal := pay_balance_pkg.get_value(l_cont_wage_id,l_first_assact_id);

583: End If;
584: open csr_get_first_assact_id (p_employer_id ,l_act_first_date, p_person_id );
585: fetch csr_get_first_assact_id into l_first_assact_id;
586: close csr_get_first_assact_id ;
587: l_test_cont_sal := pay_balance_pkg.get_value(l_cont_wage_id,l_first_assact_id);
588: if l_test_cont_sal <= to_number(pay_kw_general.get_table_bands(p_effective_date,'Kuwait Social Insurance','MIN_LOW')) then
589: l_test_cont_sal := to_number(pay_kw_general.get_table_bands(p_effective_date,'Kuwait Social Insurance','MIN_LOW'));
590: elsif l_test_cont_sal >= to_number(pay_kw_general.get_table_bands(p_effective_date,'Kuwait Social Insurance','MAX_HIGH')) then
591: l_test_cont_sal := to_number(pay_kw_general.get_table_bands(p_effective_date,'Kuwait Social Insurance','MAX_HIGH'));

Line 596: l_cur_sal := pay_balance_pkg.get_value(l_subject_to_social_id ,p_assact_cur_id)*1000;

592: end if;
593: l_first_sal := l_test_cont_sal*1000;
594:
595: /*
596: l_cur_sal := pay_balance_pkg.get_value(l_subject_to_social_id ,p_assact_cur_id)*1000;
597: */
598:
599: /*** Changed after kuwait annual report 55 ****/
600: l_cur_sal := pay_balance_pkg.get_value(l_tot_earn_id,p_assact_cur_id)*1000;

Line 600: l_cur_sal := pay_balance_pkg.get_value(l_tot_earn_id,p_assact_cur_id)*1000;

596: l_cur_sal := pay_balance_pkg.get_value(l_subject_to_social_id ,p_assact_cur_id)*1000;
597: */
598:
599: /*** Changed after kuwait annual report 55 ****/
600: l_cur_sal := pay_balance_pkg.get_value(l_tot_earn_id,p_assact_cur_id)*1000;
601:
602: /* l_first_social := (pay_balance_pkg.get_value(l_basic_social_id ,l_first_assact_id) +
603: pay_balance_pkg.get_value(l_supplementary_social_id ,l_first_assact_id) +
604: pay_balance_pkg.get_value(l_additional_social_id ,l_first_assact_id) ) * 1000;

Line 602: /* l_first_social := (pay_balance_pkg.get_value(l_basic_social_id ,l_first_assact_id) +

598:
599: /*** Changed after kuwait annual report 55 ****/
600: l_cur_sal := pay_balance_pkg.get_value(l_tot_earn_id,p_assact_cur_id)*1000;
601:
602: /* l_first_social := (pay_balance_pkg.get_value(l_basic_social_id ,l_first_assact_id) +
603: pay_balance_pkg.get_value(l_supplementary_social_id ,l_first_assact_id) +
604: pay_balance_pkg.get_value(l_additional_social_id ,l_first_assact_id) ) * 1000;
605: */
606:

Line 603: pay_balance_pkg.get_value(l_supplementary_social_id ,l_first_assact_id) +

599: /*** Changed after kuwait annual report 55 ****/
600: l_cur_sal := pay_balance_pkg.get_value(l_tot_earn_id,p_assact_cur_id)*1000;
601:
602: /* l_first_social := (pay_balance_pkg.get_value(l_basic_social_id ,l_first_assact_id) +
603: pay_balance_pkg.get_value(l_supplementary_social_id ,l_first_assact_id) +
604: pay_balance_pkg.get_value(l_additional_social_id ,l_first_assact_id) ) * 1000;
605: */
606:
607: /*** Changed after kuwait annual report 103 ***/

Line 604: pay_balance_pkg.get_value(l_additional_social_id ,l_first_assact_id) ) * 1000;

600: l_cur_sal := pay_balance_pkg.get_value(l_tot_earn_id,p_assact_cur_id)*1000;
601:
602: /* l_first_social := (pay_balance_pkg.get_value(l_basic_social_id ,l_first_assact_id) +
603: pay_balance_pkg.get_value(l_supplementary_social_id ,l_first_assact_id) +
604: pay_balance_pkg.get_value(l_additional_social_id ,l_first_assact_id) ) * 1000;
605: */
606:
607: /*** Changed after kuwait annual report 103 ***/
608:

Line 610: l_first_social := pay_balance_pkg.get_value(l_soc_bal_id,l_first_assact_id)*1000;

606:
607: /*** Changed after kuwait annual report 103 ***/
608:
609: If l_soc_bal_id is not null then
610: l_first_social := pay_balance_pkg.get_value(l_soc_bal_id,l_first_assact_id)*1000;
611: Else
612: l_first_social := 0;
613: End If;
614:

Line 615: /* l_cur_social := (pay_balance_pkg.get_value(l_basic_social_id ,p_assact_cur_id) +

611: Else
612: l_first_social := 0;
613: End If;
614:
615: /* l_cur_social := (pay_balance_pkg.get_value(l_basic_social_id ,p_assact_cur_id) +
616: pay_balance_pkg.get_value(l_supplementary_social_id ,p_assact_cur_id) +
617: pay_balance_pkg.get_value(l_additional_social_id ,p_assact_cur_id)) * 1000;
618: */
619:

Line 616: pay_balance_pkg.get_value(l_supplementary_social_id ,p_assact_cur_id) +

612: l_first_social := 0;
613: End If;
614:
615: /* l_cur_social := (pay_balance_pkg.get_value(l_basic_social_id ,p_assact_cur_id) +
616: pay_balance_pkg.get_value(l_supplementary_social_id ,p_assact_cur_id) +
617: pay_balance_pkg.get_value(l_additional_social_id ,p_assact_cur_id)) * 1000;
618: */
619:
620: If l_soc_bal_id is not null then

Line 617: pay_balance_pkg.get_value(l_additional_social_id ,p_assact_cur_id)) * 1000;

613: End If;
614:
615: /* l_cur_social := (pay_balance_pkg.get_value(l_basic_social_id ,p_assact_cur_id) +
616: pay_balance_pkg.get_value(l_supplementary_social_id ,p_assact_cur_id) +
617: pay_balance_pkg.get_value(l_additional_social_id ,p_assact_cur_id)) * 1000;
618: */
619:
620: If l_soc_bal_id is not null then
621: l_cur_social := pay_balance_pkg.get_value(l_soc_bal_id,p_assact_cur_id)*1000;

Line 621: l_cur_social := pay_balance_pkg.get_value(l_soc_bal_id,p_assact_cur_id)*1000;

617: pay_balance_pkg.get_value(l_additional_social_id ,p_assact_cur_id)) * 1000;
618: */
619:
620: If l_soc_bal_id is not null then
621: l_cur_social := pay_balance_pkg.get_value(l_soc_bal_id,p_assact_cur_id)*1000;
622: Else
623: l_cur_social := 0;
624: End If;
625: