DBA Data[Home] [Help]

APPS.PAY_PAYROLLS_F_PKG dependencies on PAY_ELEMENT_LINKS_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 1141: from pay_element_links_f el

1137: and asg.effective_end_date >= p_validation_start_date;
1138: --
1139: cursor csr_chk_element_link is
1140: select 'found'
1141: from pay_element_links_f el
1142: where el.payroll_id = p_payroll_id
1143: and el.effective_start_date <= p_validation_end_date
1144: and el.effective_end_date >= p_validation_start_date;
1145: