APPS.PAY_GB_NICAR_06042002 dependencies on PER_TIME_PERIOD_TYPES

Line 1512: l_pay_period_type per_time_period_types.period_type%type;

1508: l_msg_count number := 1;
1509: type l_msg_tabtype is table of varchar2(500) index by binary_integer;
1510: tbl_msg_table l_msg_tabtype;
1511:
1512: l_pay_period_type per_time_period_types.period_type%type;
1513: l_periods_per_period number;
1514: l_annualised_pay_period number;
1515: l_next_period_end_date date;
1516:

Line 1663: from per_time_period_types ptpt,

1659:
1660: /* Get payroll period type for payroll period currently being processed */
1661: cursor csr_period_type is
1662: select ptpt.period_type
1663: from per_time_period_types ptpt,
1664: per_time_periods ptp,
1665: per_assignments_f paf
1666: where paf.payroll_id = ptp.payroll_id
1667: and ptpt.period_type = ptp.period_type