APPS.PAY_PAYROLLS_F_PKG dependencies on HR_COMMENTS

Line 1326: hr_comments com

1322: --
1323: cursor csr_comment_rows_zap is
1324: select com.comment_id
1325: from pay_payrolls_f prl,
1326: hr_comments com
1327: where prl.payroll_id = p_payroll_id
1328: and com.comment_id = prl.comment_id
1329: for update of com.comment_id;
1330: --

Line 1334: hr_comments com

1330: --
1331: cursor csr_comment_rows_delete is
1332: select com.comment_id
1333: from pay_payrolls_f prl,
1334: hr_comments com
1335: where prl.payroll_id = p_payroll_id
1336: and prl.effective_start_date >= p_validation_start_date
1337: and com.comment_id = prl.comment_id
1338: and not exists

Line 1368: delete from hr_comments

1364: delete from pay_payroll_gl_flex_maps gfm
1365: where gfm.payroll_id = p_payroll_id;
1366: --
1367: for v_com_rec in csr_comment_rows_zap loop
1368: delete from hr_comments
1369: where current of csr_comment_rows_zap;
1370: end loop;
1371: --
1372: -- Payroll Lists are created by default for all the security profiles

Line 1447: delete from hr_comments

1443: --
1444: -- Remove any comments that only exist after the date on which the payroll
1445: -- is being closed down.
1446: for v_com_rec in csr_comment_rows_delete loop
1447: delete from hr_comments
1448: where current of csr_comment_rows_delete;
1449: end loop;
1450: --
1451: end if;