DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PAY_PAYROLL_LIST

Line 289: INSERT INTO pay_payroll_list

285: IF (l_include_exclude_payroll_flag = 'I') THEN
286: --
287: hr_utility.set_location('hr_listgen.build_payroll_list', 10);
288: --
289: INSERT INTO pay_payroll_list
290: (payroll_id,
291: security_profile_id,
292: request_id,
293: program_application_id,

Line 314: INSERT INTO pay_payroll_list

310: ELSE -- exclude payrolls
311: --
312: hr_utility.set_location('hr_listgen.build_payroll_list', 20);
313: --
314: INSERT INTO pay_payroll_list
315: (payroll_id,
316: security_profile_id,
317: request_id,
318: program_application_id,

Line 1155: fnd_dsql.add_text( ' , pay_payroll_list ppl ');

1151: fnd_dsql.add_text(', per_position_list pl ');
1152: end if;
1153:
1154: if p_sec_rec.view_all_payrolls_flag='N' then
1155: fnd_dsql.add_text( ' , pay_payroll_list ppl ');
1156: end if;
1157:
1158: if p_sec_rec.view_all_organizations_flag='Y' then
1159: null;

Line 1649: from pay_payroll_list

1645: --
1646: hr_utility.set_location(l_proc, 40);
1647: -- Clearing Payroll static list
1648: delete
1649: from pay_payroll_list
1650: where security_profile_id = p_security_profile_id;
1651: --
1652: hr_utility.set_location('Leaving : '||l_proc, 99);
1653: --