DBA Data[Home] [Help]

APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on HR_ASSIGNMENT_SET

Line 19: g_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

15:
16: g_package VARCHAR2(100);
17:
18: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
19: g_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
20: g_business_group_id per_people_f.business_group_id%TYPE;
21: g_financial_year DATE;
22: g_processing_mode VARCHAR2(1);
23:

Line 609: AND hr_assignment_set.assignment_in_set(g_assignment_set_id, assignment.assignment_id) = 'Y'

605: AND entry.element_link_id = link.element_link_id
606: AND entry.assignment_id = assignment.assignment_id
607: AND link.business_group_id = person.business_group_id
608: AND (g_payroll_id is null OR assignment.payroll_id = g_payroll_id)
609: AND hr_assignment_set.assignment_in_set(g_assignment_set_id, assignment.assignment_id) = 'Y'
610: AND g_financial_year BETWEEN person.effective_start_date
611: AND person.effective_end_date
612: AND g_financial_year BETWEEN assignment.effective_start_date
613: AND assignment.effective_end_date