APPS.PAY_PAY_BUS dependencies on PER_TIME_PERIOD_RULES

Line 1010: from per_time_period_rules tpr

1006: --
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: --

Line 1714: l_basic_period_type per_time_period_rules.basic_period_type%type;

1710: --
1711: l_proc varchar2(72) := g_package||'insert_validate';
1712: l_business_group_id number(15);
1713:
1714: l_basic_period_type per_time_period_rules.basic_period_type%type;
1715: l_periods_per_period per_time_period_rules.periods_per_period%type;
1716: l_arrears_flag_rule pay_legislation_rules.rule_mode%type;
1717: --
1718: Begin

Line 1715: l_periods_per_period per_time_period_rules.periods_per_period%type;

1711: l_proc varchar2(72) := g_package||'insert_validate';
1712: l_business_group_id number(15);
1713:
1714: l_basic_period_type per_time_period_rules.basic_period_type%type;
1715: l_periods_per_period per_time_period_rules.periods_per_period%type;
1716: l_arrears_flag_rule pay_legislation_rules.rule_mode%type;
1717: --
1718: Begin
1719: hr_utility.set_location('Entering:'||l_proc, 5);