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_ANNUAL_REPORTS dependencies on PAY_BALANCE_PKG

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

508: OPEN csr_get_first_assact (t_store_assact(j).assignment_id,l_effective_date);
509: FETCH csr_get_first_assact into l_first_date,l_first_assact_id;
510: CLOSE csr_get_first_assact;
511:
512: l_monthly_earning := pay_balance_pkg.get_value(l_tot_earn_bal_id,t_store_assact(j).assignment_action_id);
513:
514: OPEN csr_get_assact_first(t_store_assact(j).assignment_id,l_effective_date);
515: FETCH csr_get_assact_first INTO l_first_date_earned,l_first_assact;
516: CLOSE csr_get_assact_first;

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

529: CLOSE csr_get_assact_one;
530:
531: If l_social_id is not null THEN
532: If l_assact_one is not null then
533: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);
534: Else
535: l_first_social := 0;
536: End If;
537: Else

Line 544: l_second_social := pay_balance_pkg.get_value(l_bonus,l_assact_one);

540:
541: /* added Oct 2012 */
542: If l_bonus is not null THEN
543: If l_assact_one is not null then
544: l_second_social := pay_balance_pkg.get_value(l_bonus,l_assact_one);
545: Else
546: l_second_social := 0;
547: End If;
548: Else

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

1024: OPEN csr_get_assact (t_store_assact(j).assignment_id,l_effective_date);
1025: LOOP
1026: FETCH csr_get_assact into t_store_recs(v).date_earned,t_store_recs(v).assignment_action_id;
1027: EXIT WHEN csr_get_assact%notfound;
1028: l_supp_bal := pay_balance_pkg.get_value(l_supp_id,t_store_recs(v).assignment_action_id);
1029: l_tot_earn := pay_balance_pkg.get_value(l_tot_earn_id,t_store_recs(v).assignment_action_id);
1030: t_store_recs(v).supp_bal_value := l_supp_bal;
1031: t_store_recs(v).tot_earn_value := l_tot_earn;
1032: v:= v + 1;

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

1025: LOOP
1026: FETCH csr_get_assact into t_store_recs(v).date_earned,t_store_recs(v).assignment_action_id;
1027: EXIT WHEN csr_get_assact%notfound;
1028: l_supp_bal := pay_balance_pkg.get_value(l_supp_id,t_store_recs(v).assignment_action_id);
1029: l_tot_earn := pay_balance_pkg.get_value(l_tot_earn_id,t_store_recs(v).assignment_action_id);
1030: t_store_recs(v).supp_bal_value := l_supp_bal;
1031: t_store_recs(v).tot_earn_value := l_tot_earn;
1032: v:= v + 1;
1033: END LOOP;

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

1942: /* Get Social allowance */
1943:
1944: If l_social_id is not null then
1945: If l_assact_one is not null then
1946: l_first_social := pay_balance_pkg.get_value(l_social_id,l_assact_one);
1947: Else
1948: l_first_social := 0;
1949: End If;
1950: Else

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

1952: End If;
1953:
1954: /* Get current salary */
1955:
1956: l_curr_val := pay_balance_pkg.get_value(l_tot_earn_id,t_store_assact(j).assignment_action_id);
1957:
1958: /* Get amount subject to supplementary_social_insurance */
1959:
1960: l_subject_supp_val := pay_balance_pkg.get_value(l_supp_base_id,t_store_assact(j).assignment_action_id);

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

1956: l_curr_val := pay_balance_pkg.get_value(l_tot_earn_id,t_store_assact(j).assignment_action_id);
1957:
1958: /* Get amount subject to supplementary_social_insurance */
1959:
1960: l_subject_supp_val := pay_balance_pkg.get_value(l_supp_base_id,t_store_assact(j).assignment_action_id);
1961:
1962: /* Get Last salary date */
1963:
1964: OPEN csr_get_assact_de (t_store_assact(j).assignment_id, l_effective_date);

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

1967: FETCH csr_get_assact_de into l_temp_date , l_temp_assact;
1968: EXIT WHEN csr_get_assact_de%NOTFOUND;
1969: l_diff_exists := 'N';
1970:
1971: l_temp_val := pay_balance_pkg.get_value(l_tot_earn_id,l_temp_assact);
1972:
1973: If l_curr_val <> l_temp_val then
1974: l_diff_exists := 'Y';
1975: OPEN csr_get_last_sal_date(t_store_assact(j).assignment_id,l_temp_date);