DBA Data[Home] [Help]

APPS.PAY_KR_HIA_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 114: hr_organization_information hoi1

110: asg.establishment_id
111: FROM per_assignments_f asg,
112: pay_payroll_actions xppa,
113: hr_organization_units hou1,
114: hr_organization_information hoi1
115: WHERE xppa.payroll_action_id = p_payroll_action_id
116: and hou1.business_group_id = g_pact.business_group_id --3506171
117: and hoi1.organization_id = hou1.organization_id
118: and hoi1.org_information_context = 'KR_HI_INFORMATION'

Line 302: hr_organization_information hhoi,

298: per_people_f pp,
299: per_assignments_f pa,
300: pay_assignment_actions paa,
301: pay_payroll_actions ppa,
302: hr_organization_information hhoi,
303: per_periods_of_service pds
304: WHERE ppa.payroll_action_id = g_pact.payroll_action_id
305: AND paa.payroll_action_id = ppa.payroll_action_id
306: AND pa.assignment_id = paa.assignment_id

Line 563: l_bp_hi_number hr_organization_information.org_information1%type := NULL; --3506171

559: RETURN NUMBER
560: IS
561: l_count NUMBER := 0;
562: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
563: l_bp_hi_number hr_organization_information.org_information1%type := NULL; --3506171
564: l_reported_date DATE := NULL;
565: l_number_of_copies NUMBER := 0;
566: l_request_id NUMBER := 0;
567: l_print_return BOOLEAN;