DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 1785: FROM per_time_period_types

1781: ORDER BY fnd_date.canonical_to_date(org_information1);
1782: --
1783: CURSOR csr_get_no_pay_period(c_payroll_type VARCHAR2) IS
1784: SELECT number_per_fiscal_year
1785: FROM per_time_period_types
1786: WHERE period_type = DECODE(c_payroll_type,'MONTH','Calendar Month','WEEK','Week','LMONTH','Lunar Month');
1787: --
1788: y NUMBER ;
1789: l_flat_rate_taxation NUMBER := 0;