APPS.PAY_PAY_BUS dependencies on PAY_LEGISLATION_RULES

Line 1101: from pay_legislation_rules lru

1097: ) is
1098: --
1099: cursor c_get_legislation_rule is
1100: select rule_type, rule_mode
1101: from pay_legislation_rules lru
1102: where lru.legislation_code = p_legislation_code
1103: and lru.rule_type = nvl(p_rule_type,lru.rule_type);
1104: --
1105: begin

Line 1157: l_cutoff_date_rule pay_legislation_rules.rule_mode%type;

1153: ,p_arrears_flag_rule out nocopy varchar2
1154: ) is
1155: --
1156: l_max_offset number;
1157: l_cutoff_date_rule pay_legislation_rules.rule_mode%type;
1158: l_dd_date_rule pay_legislation_rules.rule_mode%type;
1159: l_pay_adv_date_rule pay_legislation_rules.rule_mode%type;
1160: l_pay_date_rule pay_legislation_rules.rule_mode%type;
1161: --

Line 1158: l_dd_date_rule pay_legislation_rules.rule_mode%type;

1154: ) is
1155: --
1156: l_max_offset number;
1157: l_cutoff_date_rule pay_legislation_rules.rule_mode%type;
1158: l_dd_date_rule pay_legislation_rules.rule_mode%type;
1159: l_pay_adv_date_rule pay_legislation_rules.rule_mode%type;
1160: l_pay_date_rule pay_legislation_rules.rule_mode%type;
1161: --
1162: begin

Line 1159: l_pay_adv_date_rule pay_legislation_rules.rule_mode%type;

1155: --
1156: l_max_offset number;
1157: l_cutoff_date_rule pay_legislation_rules.rule_mode%type;
1158: l_dd_date_rule pay_legislation_rules.rule_mode%type;
1159: l_pay_adv_date_rule pay_legislation_rules.rule_mode%type;
1160: l_pay_date_rule pay_legislation_rules.rule_mode%type;
1161: --
1162: begin
1163: --

Line 1160: l_pay_date_rule pay_legislation_rules.rule_mode%type;

1156: l_max_offset number;
1157: l_cutoff_date_rule pay_legislation_rules.rule_mode%type;
1158: l_dd_date_rule pay_legislation_rules.rule_mode%type;
1159: l_pay_adv_date_rule pay_legislation_rules.rule_mode%type;
1160: l_pay_date_rule pay_legislation_rules.rule_mode%type;
1161: --
1162: begin
1163: --
1164: get_legislation_rules

Line 1716: l_arrears_flag_rule pay_legislation_rules.rule_mode%type;

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);
1720: --

Line 1863: l_arrears_flag_rule pay_legislation_rules.rule_mode%type;

1859: ) is
1860: --
1861: l_proc varchar2(72) := g_package||'update_validate';
1862: l_dummy varchar2(15);
1863: l_arrears_flag_rule pay_legislation_rules.rule_mode%type;
1864: l_business_group_id pay_all_payrolls_f.business_group_id%type;
1865:
1866: --
1867: Begin