APPS.PAY_DK_LABOR_COST_REPORT dependencies on PAY_BALANCE_PKG

Line 306: l_employer_atp := pay_balance_pkg.get_value(

302:
303: FOR c_atp_assignments IN csr_atp_assignments(l_start_date,l_end_date,
304: l_business_group_id,p_legal_employer,p_payroll)
305: LOOP
306: l_employer_atp := pay_balance_pkg.get_value(
307: p_defined_balance_id => l_employer_atp_balance_id,
308: p_assignment_action_id => c_atp_assignments.assignment_action_id,
309: p_tax_unit_id => p_legal_employer,
310: p_jurisdiction_code => NULL,

Line 315: l_employee_atp := pay_balance_pkg.get_value(

311: p_source_id => NULL,
312: p_tax_group => NULL,
313: p_date_earned => NULL);
314:
315: l_employee_atp := pay_balance_pkg.get_value(
316: p_defined_balance_id => l_employee_atp_balance_id,
317: p_assignment_action_id => c_atp_assignments.assignment_action_id,
318: p_tax_unit_id => p_legal_employer,
319: p_jurisdiction_code => NULL,

Line 346: l_full_atp_hours := pay_balance_pkg.get_value(

342: -- Completely no ATP condition
343: IF (l_age_on_end < l_atp_employee_age_low) OR
344: (l_age_on_start > l_atp_employee_age_high)
345: THEN
346: l_full_atp_hours := pay_balance_pkg.get_value(
347: p_defined_balance_id => l_total_atp_hours_id,
348: p_assignment_action_id => c_atp_assignments.assignment_action_id,
349: p_tax_unit_id => p_legal_employer,
350: p_jurisdiction_code => NULL,

Line 380: l_partial_atp_hours := pay_balance_pkg.get_value(

376: ,l_start_date,l_end_date_before_age_change);
377: FETCH csr_assgid_before_change INTO l_assgid_before_change;
378: CLOSE csr_assgid_before_change;
379: IF l_assgid_before_change IS NOT NULL THEN --10322489
380: l_partial_atp_hours := pay_balance_pkg.get_value(
381: p_defined_balance_id => l_total_atp_hours_id,
382: p_assignment_action_id => l_assgid_before_change,
383: p_tax_unit_id => p_legal_employer,
384: p_jurisdiction_code => NULL,

Line 399: l_full_atp_hours := pay_balance_pkg.get_value(

395: --If Age crossed ATP HIGH during the year.
396: ELSIF (l_age_on_start = (l_atp_employee_age_high) AND
397: l_age_on_end = l_atp_employee_age_high + 1) --9127531
398: THEN
399: l_full_atp_hours := pay_balance_pkg.get_value(
400: p_defined_balance_id => l_total_atp_hours_id,
401: p_assignment_action_id => c_atp_assignments.assignment_action_id,
402: p_tax_unit_id => p_legal_employer,
403: p_jurisdiction_code => NULL,

Line 423: l_worked_hours := pay_balance_pkg.get_value(

419:
420: FOR c_non_atp_assignments IN csr_non_atp_assignments(l_start_date,l_end_date,
421: l_business_group_id,p_legal_employer,p_payroll)
422: LOOP
423: l_worked_hours := pay_balance_pkg.get_value(
424: p_defined_balance_id => l_worked_hours_id,
425: p_assignment_action_id => c_non_atp_assignments.assignment_action_id,
426: p_tax_unit_id => p_legal_employer,
427: p_jurisdiction_code => NULL,