[Home] [Help]
1070: ,cp_end_date in date
1071: ,cp_tax_unit_id in number
1072: ,cp_payroll_id in number) is
1073: select nvl(min(assignment_action_id),-1)
1074: from pay_assignment_actions paa,
1075: pay_payroll_actions ppa,
1076: pay_payrolls_f ppf
1077: where ppa.business_group_id +0 = cp_business_group_id
1078: and ppa.payroll_action_id = paa.payroll_action_id