DBA Data[Home] [Help]

APPS.PAY_GB_NICAR_06042002 dependencies on PER_TIME_PERIODS

Line 1664: per_time_periods ptp,

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
1668: and paf.assignment_id = p_assignment_id

Line 1674: from per_time_periods ptp,

1670:
1671: /* Get end date of next payroll period after the one currently being processed */
1672: cursor csr_next_end_date is
1673: select ptp.end_date
1674: from per_time_periods ptp,
1675: pay_all_payrolls_f papf,
1676: per_assignments_f paf
1677: where paf.payroll_id = papf.payroll_id
1678: and papf.payroll_id = ptp.payroll_id