DBA Data[Home] [Help]

APPS.PAY_PAY_BUS dependencies on PER_TIME_PERIOD_TYPES

Line 1004: from per_time_period_types tpt

1000: ) is
1001: --
1002: cursor csr_chk_parent is
1003: select null
1004: from per_time_period_types tpt
1005: where tpt.period_type = p_period_type;
1006: --
1007: cursor csr_basic_period_type is
1008: select tpr.basic_period_type

Line 1011: ,per_time_period_types tpt

1007: cursor csr_basic_period_type is
1008: select tpr.basic_period_type
1009: ,tpr.periods_per_period
1010: from per_time_period_rules tpr
1011: ,per_time_period_types tpt
1012: where tpr.number_per_fiscal_year = tpt.number_per_fiscal_year
1013: and tpt.period_type = p_period_type;
1014: --
1015: begin

Line 1017: -- Period Type must exist in PER_TIME_PERIOD_TYPES

1013: and tpt.period_type = p_period_type;
1014: --
1015: begin
1016: --
1017: -- Period Type must exist in PER_TIME_PERIOD_TYPES
1018: --
1019: open csr_chk_parent;
1020: fetch csr_chk_parent into g_exists;
1021: if csr_chk_parent%notfound then