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

Line 1763: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);

1759: OPEN csr_tax_unit(p_assignment_action_id);
1760: FETCH csr_tax_unit INTO l_tu_id;
1761: CLOSE csr_tax_unit;
1762:
1763: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
1764: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1765: IF g_user_balance_table.count > 0 THEN
1766:
1767: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

Line 1764: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

1760: FETCH csr_tax_unit INTO l_tu_id;
1761: CLOSE csr_tax_unit;
1762:
1763: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
1764: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1765: IF g_user_balance_table.count > 0 THEN
1766:
1767: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
1768: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

Line 1768: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

1764: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1765: IF g_user_balance_table.count > 0 THEN
1766:
1767: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
1768: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
1769: IF l_balance_value > 0 THEN
1770:
1771: pay_action_information_api.create_action_information (
1772: p_action_information_id => l_action_info_id

Line 2027: l_sal_inc_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2023: /* Archive Salary Certificate */
2024:
2025: /*Salary in Money PTD*/
2026: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_IN_MONEY_ASG_PTD');
2027: l_sal_inc_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2028:
2029: /*Salary in Money YTD*/
2030: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_IN_MONEY_ASG_YTD');
2031: l_sal_inc_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

Line 2031: l_sal_inc_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2027: l_sal_inc_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2028:
2029: /*Salary in Money YTD*/
2030: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_IN_MONEY_ASG_YTD');
2031: l_sal_inc_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2032:
2033: /*Benefits in Kind PTD*/
2034: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BENEFITS_IN_KIND_ASG_PTD');
2035: l_bik_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

Line 2035: l_bik_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2031: l_sal_inc_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2032:
2033: /*Benefits in Kind PTD*/
2034: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BENEFITS_IN_KIND_ASG_PTD');
2035: l_bik_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2036:
2037: /*Benefits in Kind YTD*/
2038: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BENEFITS_IN_KIND_ASG_YTD');
2039: l_bik_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

Line 2039: l_bik_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2035: l_bik_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2036:
2037: /*Benefits in Kind YTD*/
2038: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BENEFITS_IN_KIND_ASG_YTD');
2039: l_bik_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2040:
2041:
2042: /*Taxable Income PTD*/
2043:

Line 2046: l_tax_base_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2042: /*Taxable Income PTD*/
2043:
2044: IF l_tax_card_type <> 'TS' THEN
2045: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_BASE_ASG_PTD');
2046: l_tax_base_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2047:
2048: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_BASE_ASG_YTD');
2049: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2050:

Line 2049: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2045: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_BASE_ASG_PTD');
2046: l_tax_base_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2047:
2048: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_BASE_ASG_YTD');
2049: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2050:
2051: BEGIN
2052:
2053: l_tax_base_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

Line 2053: l_tax_base_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

2049: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2050:
2051: BEGIN
2052:
2053: l_tax_base_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2054: p_assignment_id,
2055: trunc(p_date_earned,'Y') -1 );
2056:
2057: EXCEPTION

Line 2065: l_tax_ded_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2061:
2062:
2063:
2064: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_ASG_PTD');
2065: l_tax_ded_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2066:
2067: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_ASG_YTD');
2068: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2069:

Line 2068: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2064: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_ASG_PTD');
2065: l_tax_ded_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2066:
2067: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WITHHOLDING_TAX_ASG_YTD');
2068: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2069:
2070:
2071: BEGIN
2072: l_tax_ded_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

Line 2072: l_tax_ded_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

2068: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2069:
2070:
2071: BEGIN
2072: l_tax_ded_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2073: p_assignment_id,
2074: trunc(p_date_earned,'Y') -1 );
2075: EXCEPTION
2076: when no_data_found then

Line 2085: l_tax_base_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2081:
2082:
2083: ELSE
2084: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_BASE_ASG_PTD');
2085: l_tax_base_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2086:
2087: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_BASE_ASG_YTD');
2088: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2089:

Line 2088: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2084: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_BASE_ASG_PTD');
2085: l_tax_base_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2086:
2087: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_BASE_ASG_YTD');
2088: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2089:
2090: begin
2091: l_tax_base_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2092: p_assignment_id,

Line 2091: l_tax_base_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

2087: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_BASE_ASG_YTD');
2088: l_tax_base_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2089:
2090: begin
2091: l_tax_base_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2092: p_assignment_id,
2093: trunc(p_date_earned,'Y') -1 );
2094: exception
2095: when no_data_found then

Line 2100: l_tax_ded_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2096: l_tax_base_prev_ytd := 0;
2097: end;
2098:
2099: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_ASG_PTD');
2100: l_tax_ded_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2101:
2102: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_ASG_YTD');
2103: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2104:

Line 2103: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2099: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_ASG_PTD');
2100: l_tax_ded_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2101:
2102: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_ASG_YTD');
2103: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2104:
2105: begin
2106: l_tax_ded_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2107: p_assignment_id,

Line 2106: l_tax_ded_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

2102: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAX_AT_SOURCE_ASG_YTD');
2103: l_tax_ded_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2104:
2105: begin
2106: l_tax_ded_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2107: p_assignment_id,
2108: trunc(p_date_earned,'Y') -1 );
2109: exception
2110: when no_data_found then

Line 2118: l_sal_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2114: END IF;
2115:
2116: /*
2117: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_SUBJECT_TO_PENSION_ASG_PTD');
2118: l_sal_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2119:
2120: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAXABLE_EXPENSES_SUBJECT_TO_PENSION_ASG_PTD');
2121: l_tax_exps_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2122:

Line 2121: l_tax_exps_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2117: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_SUBJECT_TO_PENSION_ASG_PTD');
2118: l_sal_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2119:
2120: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAXABLE_EXPENSES_SUBJECT_TO_PENSION_ASG_PTD');
2121: l_tax_exps_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2122:
2123: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BIK_SUBJECT_TO_PENSION_ASG_PTD');
2124: l_bik_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2125: */

Line 2124: l_bik_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2120: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAXABLE_EXPENSES_SUBJECT_TO_PENSION_ASG_PTD');
2121: l_tax_exps_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2122:
2123: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BIK_SUBJECT_TO_PENSION_ASG_PTD');
2124: l_bik_sub_to_pen_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2125: */
2126:
2127: begin
2128: /*

Line 2135: l_pen_ins_cont_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2131: + l_bik_sub_to_pen_ptd;
2132: */
2133:
2134: l_defined_balance_id := GET_DEFINED_BALANCE_ID('PENSION_ASG_PTD');
2135: l_pen_ins_cont_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2136:
2137:
2138: exception
2139: when no_data_found then

Line 2144: l_sal_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2140: l_pen_ins_cont_ptd := 0;
2141: end;
2142: /*
2143: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_SUBJECT_TO_PENSION_ASG_YTD');
2144: l_sal_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2145:
2146: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAXABLE_EXPENSES_SUBJECT_TO_PENSION_ASG_YTD');
2147: l_tax_exps_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2148:

Line 2147: l_tax_exps_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2143: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SALARY_SUBJECT_TO_PENSION_ASG_YTD');
2144: l_sal_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2145:
2146: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAXABLE_EXPENSES_SUBJECT_TO_PENSION_ASG_YTD');
2147: l_tax_exps_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2148:
2149: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BIK_SUBJECT_TO_PENSION_ASG_YTD');
2150: l_bik_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2151:

Line 2150: l_bik_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2146: l_defined_balance_id := GET_DEFINED_BALANCE_ID('TAXABLE_EXPENSES_SUBJECT_TO_PENSION_ASG_YTD');
2147: l_tax_exps_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2148:
2149: l_defined_balance_id := GET_DEFINED_BALANCE_ID('BIK_SUBJECT_TO_PENSION_ASG_YTD');
2150: l_bik_sub_to_pen_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2151:
2152:
2153: l_pen_ins_cont_ytd := l_sal_sub_to_pen_ytd
2154: + l_tax_exps_sub_to_pen_ytd

Line 2163: l_pen_ins_cont_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2159:
2160: BEGIN
2161:
2162: l_defined_balance_id := GET_DEFINED_BALANCE_ID('PENSION_ASG_YTD');
2163: l_pen_ins_cont_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2164: exception
2165: when no_data_found then
2166: l_pen_ins_cont_ytd := 0;
2167: end;

Line 2171: l_union_mem_fee_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2167: end;
2168:
2169: /*Union Dues*/
2170: l_defined_balance_id := GET_DEFINED_BALANCE_ID('CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_ASG_PTD');
2171: l_union_mem_fee_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2172:
2173: l_defined_balance_id := GET_DEFINED_BALANCE_ID('CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_ASG_YTD');
2174: l_union_mem_fee_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2175:

Line 2174: l_union_mem_fee_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2170: l_defined_balance_id := GET_DEFINED_BALANCE_ID('CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_ASG_PTD');
2171: l_union_mem_fee_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2172:
2173: l_defined_balance_id := GET_DEFINED_BALANCE_ID('CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_ASG_YTD');
2174: l_union_mem_fee_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2175:
2176:
2177: /*Unemployment code to be inserted here*/
2178: l_defined_balance_id := GET_DEFINED_BALANCE_ID('UNEMPLOYMENT_INSURANCE_ASG_PTD');

Line 2179: l_unemp_ins_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2175:
2176:
2177: /*Unemployment code to be inserted here*/
2178: l_defined_balance_id := GET_DEFINED_BALANCE_ID('UNEMPLOYMENT_INSURANCE_ASG_PTD');
2179: l_unemp_ins_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2180:
2181: l_defined_balance_id := GET_DEFINED_BALANCE_ID('UNEMPLOYMENT_INSURANCE_ASG_YTD');
2182: l_unemp_ins_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2183:

Line 2182: l_unemp_ins_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2178: l_defined_balance_id := GET_DEFINED_BALANCE_ID('UNEMPLOYMENT_INSURANCE_ASG_PTD');
2179: l_unemp_ins_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2180:
2181: l_defined_balance_id := GET_DEFINED_BALANCE_ID('UNEMPLOYMENT_INSURANCE_ASG_YTD');
2182: l_unemp_ins_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2183:
2184:
2185: /* Holiday Bonus Pay to be inserted here*/
2186: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BONUS_PAY_ASG_PTD');

Line 2187: l_holiday_bonus_pay_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2183:
2184:
2185: /* Holiday Bonus Pay to be inserted here*/
2186: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BONUS_PAY_ASG_PTD');
2187: l_holiday_bonus_pay_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2188:
2189: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BONUS_PAY_ASG_YTD');
2190: l_holiday_bonus_pay_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2191:

Line 2190: l_holiday_bonus_pay_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2186: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BONUS_PAY_ASG_PTD');
2187: l_holiday_bonus_pay_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2188:
2189: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BONUS_PAY_ASG_YTD');
2190: l_holiday_bonus_pay_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2191:
2192:
2193: BEGIN
2194: l_holiday_bonus_pay_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

Line 2194: l_holiday_bonus_pay_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

2190: l_holiday_bonus_pay_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2191:
2192:
2193: BEGIN
2194: l_holiday_bonus_pay_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2195: p_assignment_id,
2196: trunc(p_date_earned,'Y') -1 );
2197: EXCEPTION
2198: when no_data_found then

Line 2205: l_holiday_comp_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2201:
2202:
2203: /* Holiday Compensation to be inserted here*/
2204: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_COMPENSATION_ASG_PTD');
2205: l_holiday_comp_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2206:
2207: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_COMPENSATION_ASG_YTD');
2208: l_holiday_comp_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2209:

Line 2208: l_holiday_comp_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2204: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_COMPENSATION_ASG_PTD');
2205: l_holiday_comp_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2206:
2207: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_COMPENSATION_ASG_YTD');
2208: l_holiday_comp_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2209:
2210:
2211: BEGIN
2212: l_holiday_comp_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

Line 2212: l_holiday_comp_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,

2208: l_holiday_comp_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2209:
2210:
2211: BEGIN
2212: l_holiday_comp_prev_ytd := pay_balance_pkg.get_value(l_defined_balance_id,
2213: p_assignment_id,
2214: trunc(p_date_earned,'Y') -1 );
2215: EXCEPTION
2216: when no_data_found then

Line 2233: l_shift_pay_ptd := l_shift_pay_ptd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);

2229: FOR c_bal_attrid_rec IN c_bal_attrid('FINNISH_PAY_PERIOD_SHIFT_PAY')
2230: LOOP
2231: FOR c_bal_defid_rec IN c_bal_defid(c_bal_attrid_rec.attribute_id)
2232: LOOP
2233: l_shift_pay_ptd := l_shift_pay_ptd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);
2234:
2235: END LOOP;
2236: END LOOP;
2237:

Line 2242: l_shift_pay_ytd := l_shift_pay_ytd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);

2238: FOR c_bal_attrid_rec IN c_bal_attrid('FINNISH_YEARLY_SHIFT_PAY')
2239: LOOP
2240: FOR c_bal_defid_rec IN c_bal_defid(c_bal_attrid_rec.attribute_id)
2241: LOOP
2242: l_shift_pay_ytd := l_shift_pay_ytd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);
2243:
2244: END LOOP;
2245: END LOOP;
2246:

Line 2251: l_seasonal_pay_ptd := l_seasonal_pay_ptd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);

2247: FOR c_bal_attrid_rec IN c_bal_attrid('FINNISH_PAY_PERIOD_SEASONAL_PAY')
2248: LOOP
2249: FOR c_bal_defid_rec IN c_bal_defid(c_bal_attrid_rec.attribute_id)
2250: LOOP
2251: l_seasonal_pay_ptd := l_seasonal_pay_ptd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);
2252:
2253: END LOOP;
2254: END LOOP;
2255:

Line 2260: l_seasonal_pay_ytd := l_seasonal_pay_ytd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);

2256: FOR c_bal_attrid_rec IN c_bal_attrid('FINNISH_YEARLY_SEASONAL_PAY')
2257: LOOP
2258: FOR c_bal_defid_rec IN c_bal_defid(c_bal_attrid_rec.attribute_id)
2259: LOOP
2260: l_seasonal_pay_ytd := l_seasonal_pay_ytd + pay_balance_pkg.get_value(c_bal_defid_rec.defined_balance_id, p_assignment_action_id);
2261:
2262: END LOOP;
2263: END LOOP;
2264:

Line 2307: l_summer_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2303:
2304:
2305: BEGIN
2306: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SUMMER_HOLIDAY_DAYS_ENTITLEMENT_ASG_BD_HOL_YTD');
2307: l_summer_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2308: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2309: ,P_TAX_UNIT_ID => NULL
2310: ,P_JURISDICTION_CODE => NULL
2311: ,P_SOURCE_ID => NULL

Line 2325: l_winter_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2321: END;
2322:
2323: BEGIN
2324: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WINTER_HOLIDAY_DAYS_ENTITLEMENT_ASG_BD_HOL_YTD');
2325: l_winter_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2326: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2327: ,P_TAX_UNIT_ID => NULL
2328: ,P_JURISDICTION_CODE => NULL
2329: ,P_SOURCE_ID => NULL

Line 2345: l_bank_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2341: END;
2342:
2343: BEGIN
2344: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BANK_DAYS_ENTITLEMENT_ASG_BD_HOL_YTD');
2345: l_bank_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2346: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2347: ,P_TAX_UNIT_ID => NULL
2348: ,P_JURISDICTION_CODE => NULL
2349: ,P_SOURCE_ID => NULL

Line 2364: l_holiday_pay_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2360: END;
2361:
2362: BEGIN
2363: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_PAY_ENTITLEMENT_ASG_BD_HOL_YTD');
2364: l_holiday_pay_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2365: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2366: ,P_TAX_UNIT_ID => NULL
2367: ,P_JURISDICTION_CODE => NULL
2368: ,P_SOURCE_ID => NULL

Line 2385: l_holiday_comp_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2381:
2382:
2383: BEGIN
2384: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_COMPENSATION_ENTITLEMENT_ASG_BD_HOL_YTD');
2385: l_holiday_comp_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2386: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2387: ,P_TAX_UNIT_ID => NULL
2388: ,P_JURISDICTION_CODE => NULL
2389: ,P_SOURCE_ID => NULL

Line 2407: l_carryover_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2403:
2404: BEGIN
2405: l_defined_balance_id := GET_DEFINED_BALANCE_ID('CARRYOVER_HOLIDAY_DAYS_ASG_BD_HOL_YTD');
2406:
2407: l_carryover_hd_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2408: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2409: ,P_TAX_UNIT_ID => NULL
2410: ,P_JURISDICTION_CODE => NULL
2411: ,P_SOURCE_ID => NULL

Line 2426: l_carryover_hp_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2422: END;
2423:
2424: BEGIN
2425: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_PAY_CARRYOVER_ENTITLEMENT_ASG_BD_HOL_YTD');
2426: l_carryover_hp_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2427: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2428: ,P_TAX_UNIT_ID => NULL
2429: ,P_JURISDICTION_CODE => NULL
2430: ,P_SOURCE_ID => NULL

Line 2445: l_carryover_hc_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id

2441: END;
2442:
2443: BEGIN
2444: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_COMPENSATION_CARRYOVER_ENTITLEMENT_ASG_BD_HOL_YTD');
2445: l_carryover_hc_e_ptd := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_balance_id
2446: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
2447: ,P_TAX_UNIT_ID => NULL
2448: ,P_JURISDICTION_CODE => NULL
2449: ,P_SOURCE_ID => NULL

Line 2465: l_summer_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2461:
2462:
2463: BEGIN
2464: l_defined_balance_id := GET_DEFINED_BALANCE_ID('SUMMER_HOLIDAY_DAYS_TAKEN_ASG_PTD');
2465: l_summer_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2466: EXCEPTION
2467: when OTHERS then
2468: l_summer_hd_t_ptd := 0;
2469: END;

Line 2473: l_winter_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2469: END;
2470:
2471: BEGIN
2472: l_defined_balance_id := GET_DEFINED_BALANCE_ID('WINTER_HOLIDAY_DAYS_TAKEN_ASG_PTD');
2473: l_winter_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2474: EXCEPTION
2475: when OTHERS then
2476: l_winter_hd_t_ptd := 0;
2477: END;

Line 2482: l_bank_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2478:
2479:
2480: BEGIN
2481: l_defined_balance_id := GET_DEFINED_BALANCE_ID('HOLIDAY_BANK_DAYS_TAKEN_ASG_PTD');
2482: l_bank_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2483: EXCEPTION
2484: when OTHERS then
2485: l_bank_hd_t_ptd := 0;
2486: END;

Line 2490: l_carryover_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

2486: END;
2487:
2488: BEGIN
2489: l_defined_balance_id := GET_DEFINED_BALANCE_ID('CARRYOVER_HOLIDAY_DAYS_TAKEN_ASG_PTD');
2490: l_carryover_hd_t_ptd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
2491: EXCEPTION
2492: when OTHERS then
2493: l_carryover_hd_t_ptd := 0;
2494: END;

Line 2627: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);

2623: FETCH csr_tax_unit INTO l_tu_id;
2624: CLOSE csr_tax_unit;
2625:
2626:
2627: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2628: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2629:
2630: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');*/
2631: -------------------------------------------------------------

Line 2628: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));

2624: CLOSE csr_tax_unit;
2625:
2626:
2627: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2628: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2629:
2630: /*fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');*/
2631: -------------------------------------------------------------
2632: --Archive EMPLOYEE_DETAILS, PAYMENT_INFO and BALANCES