DBA Data[Home] [Help]

APPS.PAY_PAYROLLS_F_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1115: -- 1. Checks per_all_assignments_f, pay_element_links_f, --

1111: -- Validates the deletion of a payroll. --
1112: -- Arguments --
1113: -- See Below. --
1114: -- Notes --
1115: -- 1. Checks per_all_assignments_f, pay_element_links_f, --
1116: -- pay_exchange_rates_f,pay_payroll_actions, hr_assignment_sets, --
1117: -- pay_payroll_list, pay_security_payrolls, pay_message_lines. --
1118: -- 2. If the payroll record is being opened up then make sure that the --
1119: -- default payment method on the last row is valid for the new lifetime --

Line 1134: from per_all_assignments_f asg

1130: ) is
1131: --
1132: cursor csr_chk_assignment is
1133: select 'found'
1134: from per_all_assignments_f asg
1135: where asg.payroll_id = p_payroll_id
1136: and asg.effective_start_date <= p_validation_end_date
1137: and asg.effective_end_date >= p_validation_start_date;
1138: --