DBA Data[Home] [Help]

APPS.PAY_PAY_BUS dependencies on PAY_ALL_PAYROLLS_F

Line 33: , pay_all_payrolls_f pay

29: cursor csr_sec_grp is
30: select pbg.security_group_id,
31: pbg.legislation_code
32: from per_business_groups_perf pbg
33: , pay_all_payrolls_f pay
34: where pay.payroll_id = p_payroll_id
35: and pbg.business_group_id = pay.business_group_id;
36: --
37: -- Declare local variables

Line 103: , pay_all_payrolls_f pay

99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , pay_all_payrolls_f pay
104: where pay.payroll_id = p_payroll_id
105: and pbg.business_group_id = pay.business_group_id;
106: --
107: -- Declare local variables

Line 1864: l_business_group_id pay_all_payrolls_f.business_group_id%type;

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
1868: hr_utility.set_location('Entering:'||l_proc, 5);