APPS.HR_GBNIDIR dependencies on PER_TIME_PERIOD_TYPES

Line 1467: per_time_period_types ptpt

1463: --
1464: select ptpt.NUMBER_PER_FISCAL_YEAR
1465: into l_freq
1466: from
1467: per_time_period_types ptpt
1468: where ptpt.period_type = nvl(l_period_type,l_payroll_period_type);
1469: --
1470: --
1471: -- Find the statutory start date

Line 1651: per_time_period_types ptpt

1647: select count(distinct ptpt.NUMBER_PER_FISCAL_YEAR) into l_count
1648: from pay_payrolls_f p,
1649: per_assignments_f a,
1650: hr_soft_coding_keyflex FLEX,
1651: per_time_period_types ptpt
1652: where a.person_id = l_person_id
1653: and a.assignment_type = 'E'
1654: and a.payroll_id = p.payroll_id
1655: and nvl(hr_gbnidir.element_entry_value(

Line 1736: index(ptpt per_time_period_types_pk)

1732: use_nl(a p flex ptpt)
1733: index(a per_assignments_f_n12)
1734: index(p pay_payrolls_f_pk)
1735: index(flex hr_soft_coding_keyflex_pk)
1736: index(ptpt per_time_period_types_pk)
1737: */
1738: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq
1739: from per_all_assignments_f a,
1740: pay_all_payrolls_f p,

Line 1742: per_time_period_types ptpt

1738: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq
1739: from per_all_assignments_f a,
1740: pay_all_payrolls_f p,
1741: hr_soft_coding_keyflex FLEX,
1742: per_time_period_types ptpt
1743: where a.person_id = l_person_id
1744: and a.payroll_id = p.payroll_id
1745: /*Bug 13829747-- Added a check to pick only assignments which are of employee type*/
1746: and a.assignment_type = 'E'

Line 2281: from per_time_period_types ptpt

2277: --
2278: cursor get_frequency (c_asg_period_type varchar2,
2279: c_payroll_period_type varchar2) is
2280: select ptpt.number_per_fiscal_year
2281: from per_time_period_types ptpt
2282: where ptpt.period_type = nvl(c_asg_period_type, c_payroll_period_type);
2283: --
2284: begin
2285: --