APPS.HR_GBNIDIR dependencies on PER_TIME_PERIOD_TYPES

Line 1353: per_time_period_types ptpt

1349: --
1350: select ptpt.NUMBER_PER_FISCAL_YEAR
1351: into l_freq
1352: from
1353: per_time_period_types ptpt
1354: where ptpt.period_type = nvl(l_period_type,l_payroll_period_type);
1355: --
1356: --
1357: -- Find the statutory start date

Line 1537: per_time_period_types ptpt

1533: select count(distinct ptpt.NUMBER_PER_FISCAL_YEAR) into l_count
1534: from pay_payrolls_f p,
1535: per_assignments_f a,
1536: hr_soft_coding_keyflex FLEX,
1537: per_time_period_types ptpt
1538: where a.person_id = l_person_id
1539: and a.assignment_type = 'E'
1540: and a.payroll_id = p.payroll_id
1541: and nvl(hr_gbnidir.element_entry_value(

Line 1622: index(ptpt per_time_period_types_pk)

1618: use_nl(a p flex ptpt)
1619: index(a per_assignments_f_n12)
1620: index(p pay_payrolls_f_pk)
1621: index(flex hr_soft_coding_keyflex_pk)
1622: index(ptpt per_time_period_types_pk)
1623: */
1624: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq
1625: from per_all_assignments_f a,
1626: pay_all_payrolls_f p,

Line 1628: per_time_period_types ptpt

1624: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq
1625: from per_all_assignments_f a,
1626: pay_all_payrolls_f p,
1627: hr_soft_coding_keyflex FLEX,
1628: per_time_period_types ptpt
1629: where a.person_id = l_person_id
1630: and a.payroll_id = p.payroll_id
1631: and nvl(hr_gbnidir.element_entry_value(a.assignment_id,
1632: l_effective_date,'NI','Priority Period Type'),

Line 2165: from per_time_period_types ptpt

2161: --
2162: cursor get_frequency (c_asg_period_type varchar2,
2163: c_payroll_period_type varchar2) is
2164: select ptpt.number_per_fiscal_year
2165: from per_time_period_types ptpt
2166: where ptpt.period_type = nvl(c_asg_period_type, c_payroll_period_type);
2167: --
2168: begin
2169: --