DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_TIME_PERIOD_TYPES

Line 243: per_time_period_types.number_per_fiscal_year%TYPE

239: INDEX BY binary_integer;
240: TYPE g_max_per_table_typ IS TABLE OF NUMBER
241: INDEX BY binary_integer;
242: TYPE g_no_fisc_yr_typ IS TABLE OF
243: per_time_period_types.number_per_fiscal_year%TYPE
244: INDEX BY binary_integer;
245: TYPE g_tax_dist_table_typ IS TABLE OF VARCHAR2(3)
246: INDEX BY binary_integer;
247: TYPE g_permit_no_table_typ IS TABLE OF VARCHAR2(12)

Line 2251: FROM per_time_period_types ptpt

2247: AND business_group_id IS NULL;
2248: --
2249: cursor csr_period_type_info(p_period_type VARCHAR2) IS
2250: SELECT ptpt.number_per_fiscal_year
2251: FROM per_time_period_types ptpt
2252: WHERE p_period_type = ptpt.period_type;
2253: --
2254: cursor csr_payroll_info(p_pactid NUMBER) IS
2255: SELECT