DBA Data[Home] [Help]

APPS.PER_AE_WAGE_PROTECTION_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 64: FROM hr_organization_information

60: AND hscl.segment1 = to_char(p_employer_id)
61: AND ppf.person_id = asg.person_id
62: AND last_day(to_date('01-' || p_month || '-' ||p_year,'DD-MM-YYYY')) between ppf.effective_start_date and ppf.effective_end_date
63: AND ppf.per_information18 = (SELECT org_information1
64: FROM hr_organization_information
65: WHERE organization_id = p_business_group_id
66: AND org_information_context = 'AE_BG_DETAILS');
67:
68: RETURN l_cnt_emps;

Line 102: FROM hr_organization_information

98: and hscl.segment1 = to_char(p_employer_id)
99: and ppf.person_id = asg.person_id
100: and last_day(to_date('01-' || p_month || '-' ||p_year,'DD-MM-YYYY')) between ppf.effective_start_date and ppf.effective_end_date
101: and ppf.per_information18 = (SELECT org_information1
102: FROM hr_organization_information
103: WHERE organization_id = p_business_group_id
104: AND org_information_context = 'AE_BG_DETAILS')
105: and paa.assignment_action_id = ppv.prepay_action_id
106: and ppv.business_group_id = p_business_group_id