APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 386: from hr_organization_information hoi

382: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
383: AND (
384: (rtrim(ltrim(SCL.segment1)) in
385: (select to_char(hoi.organization_id)
386: from hr_organization_information hoi
387: where hoi.org_information_context = 'Canada Employer Identification'
388: and hoi.org_information2 = to_char(cp_pre_id) ))
389: or
390: (rtrim(ltrim(SCL.segment11)) in

Line 392: from hr_organization_information hoi

388: and hoi.org_information2 = to_char(cp_pre_id) ))
389: or
390: (rtrim(ltrim(SCL.segment11)) in
391: (select to_char(hoi.organization_id)
392: from hr_organization_information hoi
393: where hoi.org_information_context = 'Canada Employer Identification'
394: and hoi.org_information2 = to_char(cp_pre_id) ))
395: )
396: AND PPY.payroll_id = ASG.payroll_id

Line 433: from hr_organization_information hoi

429: AND ASG.effective_end_date >= cp_effective_date
430: AND SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
431: AND rtrim(ltrim(SCL.segment12)) in
432: (select to_char(hoi.organization_id)
433: from hr_organization_information hoi
434: where hoi.org_information_context = 'Canada Employer Identification'
435: and hoi.org_information2 = to_char(cp_pre_id)
436: and hoi.org_information5 = 'T4A/RL2')
437: AND PPY.payroll_id = ASG.payroll_id

Line 535: FROM hr_organization_information hoi,

531: AND assignment_id = c_assignment_id;
532:
533: CURSOR c_all_gres(cp_pre_id number) IS
534: SELECT hoi.organization_id gre_id
535: FROM hr_organization_information hoi,
536: hr_all_organization_units hou
537: WHERE hoi.org_information_context = 'Canada Employer Identification'
538: AND hoi.org_information2 = to_char(cp_pre_id)
539: AND hou.business_group_id = p_bus_grp