[Home] [Help]
119: g_total_cdep number;
120: g_total_allowance number;
121: g_total_fbt number;
122: g_total_gross number;
123: g_business_group_id hr_organization_units.organization_id%type;
124: x number;
125: g_total_workplace number; /*4015082 */
126:
127: g_balance_type_tab g_bal_type_tab;
737: end Total_Invalidity_Payments;
738:
739: --Bug#3749530 - Function modified to set globals parmaters
740: function populate_bal_ids(p_le_level IN varchar2 DEFAULT NULL,
741: p_business_group_id hr_organization_units.organization_id%type,
742: p_lst_yr_term VARCHAR2 DEFAULT NULL ) return number
743: is
744:
745: /* Bug#3004966 - Added two Balances 'Termination Deductions', 'Total_Tax_Deductions'*/
1714:
1715: l_lst_yr_start date;
1716: l_lst_fbt_yr_start date;
1717: l_assignment_id varchar2(50);
1718: l_business_group_id hr_organization_units.organization_id%type;
1719: l_legal_employer varchar2(50);
1720: l_employee_type varchar2(2);
1721: l_payroll_id varchar2(50);
1722: l_fin_year_start date;
1750: select pay_assignment_actions_s.nextval
1751: from dual;
1752:
1753: cursor c_asgids(p_assignment_id varchar2,
1754: p_business_group_id hr_organization_units.organization_id%type,
1755: p_legal_employer varchar2,
1756: p_employee_type varchar2,
1757: p_payroll_id varchar2,
1758: p_fin_year_start date,
1827: */
1828:
1829: CURSOR c_range_asgids
1830: (p_assignment_id varchar2,
1831: p_business_group_id hr_organization_units.organization_id%type,
1832: p_legal_employer varchar2,
1833: p_employee_type varchar2,
1834: p_payroll_id varchar2,
1835: p_fin_year_start date,
1898:
1899:
1900:
1901: cursor c_asgid_only(p_assignment_id varchar2,
1902: p_business_group_id hr_organization_units.organization_id%type,
1903: p_legal_employer varchar2,
1904: p_employee_type varchar2,
1905: p_payroll_id varchar2,
1906: p_fin_year_start date,