APPS.PAY_KW_ANNUAL_REPORTS dependencies on PAY_BALANCE_PKG

Line 478: l_monthly_earning := pay_balance_pkg.get_value(l_tot_earn_bal_id,t_store_assact(j).assignment_action_id);

474: OPEN csr_get_first_assact (t_store_assact(j).assignment_id,l_effective_date);
475: FETCH csr_get_first_assact into l_first_date,l_first_assact_id;
476: CLOSE csr_get_first_assact;
477:
478: l_monthly_earning := pay_balance_pkg.get_value(l_tot_earn_bal_id,t_store_assact(j).assignment_action_id);
479:
480: OPEN csr_get_assact_first(t_store_assact(j).assignment_id,l_effective_date);
481: FETCH csr_get_assact_first INTO l_first_date_earned,l_first_assact;
482: CLOSE csr_get_assact_first;

Line 499: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);

495: CLOSE csr_get_assact_one;
496:
497: If l_social_id is not null THEN
498: If l_assact_one is not null then
499: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);
500: Else
501: l_first_social := 0;
502: End If;
503: Else

Line 970: l_supp_bal := pay_balance_pkg.get_value(l_supp_id,t_store_recs(v).assignment_action_id);

966: OPEN csr_get_assact (t_store_assact(j).assignment_id,l_effective_date);
967: LOOP
968: FETCH csr_get_assact into t_store_recs(v).date_earned,t_store_recs(v).assignment_action_id;
969: EXIT WHEN csr_get_assact%notfound;
970: l_supp_bal := pay_balance_pkg.get_value(l_supp_id,t_store_recs(v).assignment_action_id);
971: l_tot_earn := pay_balance_pkg.get_value(l_tot_earn_id,t_store_recs(v).assignment_action_id);
972: t_store_recs(v).supp_bal_value := l_supp_bal;
973: t_store_recs(v).tot_earn_value := l_tot_earn;
974: v:= v + 1;

Line 971: l_tot_earn := pay_balance_pkg.get_value(l_tot_earn_id,t_store_recs(v).assignment_action_id);

967: LOOP
968: FETCH csr_get_assact into t_store_recs(v).date_earned,t_store_recs(v).assignment_action_id;
969: EXIT WHEN csr_get_assact%notfound;
970: l_supp_bal := pay_balance_pkg.get_value(l_supp_id,t_store_recs(v).assignment_action_id);
971: l_tot_earn := pay_balance_pkg.get_value(l_tot_earn_id,t_store_recs(v).assignment_action_id);
972: t_store_recs(v).supp_bal_value := l_supp_bal;
973: t_store_recs(v).tot_earn_value := l_tot_earn;
974: v:= v + 1;
975: END LOOP;

Line 1860: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);

1856: /* Get Social allowance */
1857:
1858: If l_social_id is not null then
1859: If l_assact_one is not null then
1860: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);
1861: Else
1862: l_first_social := 0;
1863: End If;
1864: Else

Line 1870: l_curr_val := pay_balance_pkg.get_value(l_tot_earn_id,t_store_assact(j).assignment_action_id);

1866: End If;
1867:
1868: /* Get current salary */
1869:
1870: l_curr_val := pay_balance_pkg.get_value(l_tot_earn_id,t_store_assact(j).assignment_action_id);
1871:
1872: /* Get amount subject to supplementary_social_insurance */
1873:
1874: l_subject_supp_val := pay_balance_pkg.get_value(l_supp_base_id,t_store_assact(j).assignment_action_id);

Line 1874: l_subject_supp_val := pay_balance_pkg.get_value(l_supp_base_id,t_store_assact(j).assignment_action_id);

1870: l_curr_val := pay_balance_pkg.get_value(l_tot_earn_id,t_store_assact(j).assignment_action_id);
1871:
1872: /* Get amount subject to supplementary_social_insurance */
1873:
1874: l_subject_supp_val := pay_balance_pkg.get_value(l_supp_base_id,t_store_assact(j).assignment_action_id);
1875:
1876: /* Get Last salary date */
1877:
1878: OPEN csr_get_assact_de (t_store_assact(j).assignment_id, l_effective_date);

Line 1885: l_temp_val := pay_balance_pkg.get_value(l_tot_earn_id,l_temp_assact);

1881: FETCH csr_get_assact_de into l_temp_date , l_temp_assact;
1882: EXIT WHEN csr_get_assact_de%NOTFOUND;
1883: l_diff_exists := 'N';
1884:
1885: l_temp_val := pay_balance_pkg.get_value(l_tot_earn_id,l_temp_assact);
1886:
1887: If l_curr_val <> l_temp_val then
1888: l_diff_exists := 'Y';
1889: OPEN csr_get_last_sal_date(t_store_assact(j).assignment_id,l_temp_date);