eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_PROVIDERS dependencies on HR_ORGANIZATION_INFORMATION

Line 658: from hr_organization_information

654: where pension_type_id = p_pension_type_id;
655:
656: Cursor csr_org_info Is
657: Select rowid
658: from hr_organization_information
659: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
660: and org_information_id = p_org_information_id
661: and organization_id = p_organization_id;
662:

Line 665: from hr_organization_information hoi,

661: and organization_id = p_organization_id;
662:
663: Cursor csr_assigned_pen_types Is
664: Select pty.pension_type_name
665: from hr_organization_information hoi,
666: pqp_pension_types_f pty
667: where hoi.org_information_context = 'PQP_NL_ER_PENSION_TYPES'
668: and hoi.org_information2 = to_char(p_pension_type_id)
669: and hoi.organization_id = p_organization_id

Line 704: -- Insert the information into the hr_organization_information table

700: fnd_message.set_name('PQP', 'PQP_230817_INVALID_PEN_TYPE');
701: fnd_message.raise_error;
702: Close csr_pen_type;
703: End If;
704: -- Insert the information into the hr_organization_information table
705: If p_transaction_mode = 'INSERT' Then
706: hr_utility.set_location(' INSERT Mode, Calling: hr_org_information_pkg.Insert_Row', 15);
707:
708: open csr_assigned_pen_types;

Line 785: -- Update the information in the hr_organization_information table

781: fnd_message.raise_error;
782: Else
783: Close csr_org_info;
784: End If;
785: -- Update the information in the hr_organization_information table
786: hr_org_information_pkg.Update_Row
787: (X_Rowid => l_hoi_rowid,
788: X_Org_Information_Id => p_org_information_id,
789: x_org_information_context => 'PQP_NL_ER_PENSION_TYPES',

Line 857: from hr_organization_information

853: ) IS
854:
855: Cursor csr_org_info(c_org_info_context in varchar2) Is
856: Select rowid
857: from hr_organization_information
858: where org_information_context = c_org_info_context
859: and org_information_id = p_org_information_id
860: and organization_id = p_organization_id;
861:

Line 864: from hr_organization_information

860: and organization_id = p_organization_id;
861:
862: Cursor c_chk_asg_employer IS
863: select 'x'
864: from hr_organization_information
865: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
866: -- ORG_INFORMATION2 is the pension_type_id from NL
867: and ORG_INFORMATION2 = to_char(p_pension_type_id)
868: and ORG_INFORMATION1 = to_char(p_organization_id);

Line 1014: from hr_organization_information

1010: ) IS
1011: -- cursor to select the rowid for the org information row
1012: Cursor csr_org_info Is
1013: Select rowid
1014: from hr_organization_information
1015: where org_information_context = 'CLASS'
1016: and org_information1 = 'HR_PAYEE'
1017: and org_information2 = 'Y'
1018: and organization_id = p_organization_id;

Line 1050: from hr_organization_information

1046: Is
1047:
1048: Cursor csr_org_info Is
1049: Select rowid,org_information_id,org_information_context,org_information1
1050: from hr_organization_information
1051: where org_information_context = 'CLASS'
1052: and org_information1 = 'FR_PENSION'
1053: and organization_id = p_organization_id;
1054:

Line 1058: from hr_organization_information

1054:
1055:
1056: Cursor csr_is_provider_assigned Is
1057: Select rowid
1058: from hr_organization_information
1059: where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
1060: and org_information1 = p_organization_id;
1061:
1062: Cursor csr_pen_types_org_info Is

Line 1064: from hr_organization_information

1060: and org_information1 = p_organization_id;
1061:
1062: Cursor csr_pen_types_org_info Is
1063: Select rowid
1064: from hr_organization_information
1065: where org_information_context = 'PQP_NL_PENSION_TYPES'
1066: and organization_id = p_organization_id;
1067:
1068: Cursor csr_is_provider_attached Is

Line 1206: from hr_organization_information

1202: where organization_id = p_organization_id;
1203:
1204: Cursor csr_org_info Is
1205: Select rowid,org_information_id,org_information_context,org_information1
1206: from hr_organization_information
1207: where org_information_context = 'CLASS'
1208: and org_information1 = 'FR_PENSION'
1209: and organization_id = p_organization_id;
1210:

Line 1213: from hr_organization_information

1209: and organization_id = p_organization_id;
1210:
1211: Cursor csr_third_party_org_info Is
1212: Select rowid,org_information_id,org_information_context,org_information1
1213: from hr_organization_information
1214: where org_information_context = 'CLASS'
1215: and org_information1 = 'HR_PAYEE'
1216: and organization_id = p_organization_id;
1217:

Line 1220: from hr_organization_information

1216: and organization_id = p_organization_id;
1217:
1218: Cursor csr_pen_types_org_info Is
1219: Select rowid
1220: from hr_organization_information
1221: where org_information_context = 'PQP_GB_PENSION_TYPES_INFO'
1222: and organization_id = p_organization_id;
1223:
1224: Cursor csr_is_provider_assigned Is

Line 1452: from hr_organization_information

1448: where organization_id = p_organization_id;
1449:
1450: Cursor csr_org_info Is
1451: Select rowid,org_information_id,org_information_context,org_information1
1452: from hr_organization_information
1453: where org_information_context = 'CLASS'
1454: and org_information1 = 'FR_PENSION'
1455: and organization_id = p_organization_id;
1456:

Line 1459: from hr_organization_information

1455: and organization_id = p_organization_id;
1456:
1457: Cursor csr_third_party_org_info Is
1458: Select rowid,org_information_id,org_information_context,org_information1
1459: from hr_organization_information
1460: where org_information_context = 'CLASS'
1461: and org_information1 = 'HR_PAYEE'
1462: and organization_id = p_organization_id;
1463:

Line 1466: from hr_organization_information

1462: and organization_id = p_organization_id;
1463:
1464: Cursor csr_pen_types_org_info Is
1465: Select rowid
1466: from hr_organization_information
1467: where org_information_context = 'HU_PENSION_TYPES_INFO'
1468: and organization_id = p_organization_id;
1469:
1470: Cursor csr_is_provider_assigned Is

Line 1697: from hr_organization_information

1693: where organization_id = p_organization_id;
1694:
1695: Cursor csr_org_info Is
1696: Select rowid,org_information_id,org_information_context,org_information1
1697: from hr_organization_information
1698: where org_information_context = 'CLASS'
1699: and org_information1 = 'IE_PENSION'
1700: and organization_id = p_organization_id;
1701:

Line 1704: from hr_organization_information

1700: and organization_id = p_organization_id;
1701:
1702: Cursor csr_third_party_org_info Is
1703: Select rowid,org_information_id,org_information_context,org_information1
1704: from hr_organization_information
1705: where org_information_context = 'CLASS'
1706: and org_information1 = 'HR_PAYEE'
1707: and organization_id = p_organization_id;
1708:

Line 1711: from hr_organization_information

1707: and organization_id = p_organization_id;
1708:
1709: Cursor csr_pen_types_org_info Is
1710: Select rowid
1711: from hr_organization_information
1712: where org_information_context = 'IE_PENSION_TYPES_INFO'
1713: and organization_id = p_organization_id;
1714:
1715: Cursor csr_is_provider_assigned Is

Line 3109: From hr_organization_information

3105: ) Is
3106:
3107: CURSOR csr_org_info IS
3108: Select rowid
3109: From hr_organization_information
3110: Where org_information_context = 'PQP_NL_ER_PENSION_TYPES'
3111: AND organization_id = p_organization_id
3112: AND org_information_id = p_org_information_id;
3113: