APPS.PAY_CA_WF_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1449: hr_organization_information hoi

1445: begin
1446: select hou.name
1447: into lv_tax_group
1448: from hr_all_organization_units hou,
1449: hr_organization_information hoi
1450: where hou.organization_id = hoi.organization_id
1451: and hoi.org_information_context = 'CLASS'
1452: and hoi.org_information1 = 'CA_TAX_GROUP'
1453: and hou.business_group_id = p_business_group_id

Line 1472: from hr_organization_information hoi1,

1468: if p_quebec = 'Y' then
1469: begin
1470: select pcp.account_number
1471: into lv_account_number
1472: from hr_organization_information hoi1,
1473: hr_organization_information hoi2,
1474: pay_ca_pmed_accounts pcp
1475: where hoi1.org_information_context = 'CLASS'
1476: and hoi1.org_information1 = 'CA_PMED'

Line 1473: hr_organization_information hoi2,

1469: begin
1470: select pcp.account_number
1471: into lv_account_number
1472: from hr_organization_information hoi1,
1473: hr_organization_information hoi2,
1474: pay_ca_pmed_accounts pcp
1475: where hoi1.org_information_context = 'CLASS'
1476: and hoi1.org_information1 = 'CA_PMED'
1477: and hoi1.org_information2 = 'Y'

Line 3585: hr_organization_information hoi

3581: begin
3582: select hou.name
3583: into lv_tax_group
3584: from hr_all_organization_units hou,
3585: hr_organization_information hoi
3586: where hou.organization_id = hoi.organization_id
3587: and hoi.org_information_context = 'CLASS'
3588: and hoi.org_information1 = 'CA_TAX_GROUP'
3589: and hou.business_group_id = p_business_group_id

Line 3608: from hr_organization_information hoi1,

3604: if p_quebec = 'Y' then
3605: begin
3606: select pcp.account_number
3607: into lv_account_number
3608: from hr_organization_information hoi1,
3609: hr_organization_information hoi2,
3610: pay_ca_pmed_accounts pcp
3611: where hoi1.org_information_context = 'CLASS'
3612: and hoi1.org_information1 = 'CA_PMED'

Line 3609: hr_organization_information hoi2,

3605: begin
3606: select pcp.account_number
3607: into lv_account_number
3608: from hr_organization_information hoi1,
3609: hr_organization_information hoi2,
3610: pay_ca_pmed_accounts pcp
3611: where hoi1.org_information_context = 'CLASS'
3612: and hoi1.org_information1 = 'CA_PMED'
3613: and hoi1.org_information2 = 'Y'

Line 4908: from hr_organization_information

4904: -- get the GRE contact
4905:
4906: cursor c_gre_contact is
4907: select org_information1
4908: from hr_organization_information
4909: where org_information_context || '' = 'Contact Information'
4910: and organization_id = p_gre_id;
4911:
4912: begin