977: IS
978: ln_start_ptr NUMBER;
979: ln_end_ptr NUMBER;
980:
981: lv_token_value pay_payroll_actions.legislative_parameters%type;
982: lv_par_value pay_payroll_actions.legislative_parameters%type;
983: BEGIN
984:
985: --4518409 lv_token_value := ' ' || p_parameter_name||'=';
978: ln_start_ptr NUMBER;
979: ln_end_ptr NUMBER;
980:
981: lv_token_value pay_payroll_actions.legislative_parameters%type;
982: lv_par_value pay_payroll_actions.legislative_parameters%type;
983: BEGIN
984:
985: --4518409 lv_token_value := ' ' || p_parameter_name||'=';
986:
1085: ,cp_tax_unit_id in number
1086: ,cp_payroll_id in number) is
1087: select nvl(min(assignment_action_id),-1)
1088: from pay_assignment_actions paa,
1089: pay_payroll_actions ppa,
1090: pay_payrolls_f ppf
1091: where ppa.business_group_id +0 = cp_business_group_id
1092: and ppa.payroll_action_id = paa.payroll_action_id
1093: and ppa.effective_date between cp_start_date and cp_end_date