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.GHR_PAH_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 78


    select
		pa_history_id,
	pa_request_id,
	process_date,
	nature_of_action_id,
	effective_date,
	altered_pa_request_id,
	person_id,
	assignment_id,
	dml_operation,
	table_name,
	pre_values_flag,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
	information31,
	information32,
	information33,
	information34,
	information35,
	information36,
	information37,
	information38,
	information39,
	information47,
	information48,
	information49,
	information40,
	information41,
	information42,
	information43,
	information44,
	information45,
	information46,
	information50,
	information51,
	information52,
	information53,
	information54,
	information55,
	information56,
	information57,
	information58,
	information59,
	information60,
	information61,
	information62,
	information63,
	information64,
	information65,
	information66,
	information67,
	information68,
	information69,
	information70,
	information71,
	information72,
	information73,
	information74,
	information75,
	information76,
	information77,
	information78,
	information79,
	information80,
	information81,
	information82,
	information83,
	information84,
	information85,
	information86,
	information87,
	information88,
	information89,
	information90,
	information91,
	information92,
	information93,
	information94,
	information95,
	information96,
	information97,
	information98,
	information99,
	information100,
	information101,
	information102,
	information103,
	information104,
	information105,
	information106,
	information107,
	information108,
	information109,
	information110,
	information111,
	information112,
	information113,
	information114,
	information115,
	information116,
	information117,
	information118,
	information119,
	information120,
	information121,
	information122,
	information123,
	information124,
	information125,
	information126,
	information127,
	information128,
	information129,
	information130,
	information131,
	information132,
	information133,
	information134,
	information135,
	information136,
	information137,
	information138,
	information139,
	information140,
	information141,
	information142,
	information143,
	information144,
	information145,
	information146,
	information147,
	information148,
	information149,
	information150,
	information151,
	information152,
	information153,
	information154,
	information155,
	information156,
	information157,
	information158,
	information159,
	information160,
	information161,
	information162,
	information163,
	information164,
	information165,
	information166,
	information167,
	information168,
	information169,
	information170,
	information171,
	information172,
	information173,
	information174,
	information175,
	information176,
	information177,
	information178,
	information179,
	information180,
	information181,
	information182,
	information183,
	information184,
	information185,
	information186,
	information187,
	information188,
	information189,
	information190,
	information191,
	information192,
	information193,
	information194,
	information195,
	information196,
	information197,
	information198,
	information199,
	information200
    from	ghr_pa_history
    where	pa_history_id = p_pa_history_id;

Line: 353


    select 	pa_history_id,
	pa_request_id,
	process_date,
	nature_of_action_id,
	effective_date,
	altered_pa_request_id,
	person_id,
	assignment_id,
	dml_operation,
	table_name,
	pre_values_flag,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
	information31,
	information32,
	information33,
	information34,
	information35,
	information36,
	information37,
	information38,
	information39,
	information47,
	information48,
	information49,
	information40,
	information41,
	information42,
	information43,
	information44,
	information45,
	information46,
	information50,
	information51,
	information52,
	information53,
	information54,
	information55,
	information56,
	information57,
	information58,
	information59,
	information60,
	information61,
	information62,
	information63,
	information64,
	information65,
	information66,
	information67,
	information68,
	information69,
	information70,
	information71,
	information72,
	information73,
	information74,
	information75,
	information76,
	information77,
	information78,
	information79,
	information80,
	information81,
	information82,
	information83,
	information84,
	information85,
	information86,
	information87,
	information88,
	information89,
	information90,
	information91,
	information92,
	information93,
	information94,
	information95,
	information96,
	information97,
	information98,
	information99,
	information100,
	information101,
	information102,
	information103,
	information104,
	information105,
	information106,
	information107,
	information108,
	information109,
	information110,
	information111,
	information112,
	information113,
	information114,
	information115,
	information116,
	information117,
	information118,
	information119,
	information120,
	information121,
	information122,
	information123,
	information124,
	information125,
	information126,
	information127,
	information128,
	information129,
	information130,
	information131,
	information132,
	information133,
	information134,
	information135,
	information136,
	information137,
	information138,
	information139,
	information140,
	information141,
	information142,
	information143,
	information144,
	information145,
	information146,
	information147,
	information148,
	information149,
	information150,
	information151,
	information152,
	information153,
	information154,
	information155,
	information156,
	information157,
	information158,
	information159,
	information160,
	information161,
	information162,
	information163,
	information164,
	information165,
	information166,
	information167,
	information168,
	information169,
	information170,
	information171,
	information172,
	information173,
	information174,
	information175,
	information176,
	information177,
	information178,
	information179,
	information180,
	information181,
	information182,
	information183,
	information184,
	information185,
	information186,
	information187,
	information188,
	information189,
	information190,
	information191,
	information192,
	information193,
	information194,
	information195,
	information196,
	information197,
	information198,
	information199,
	information200
    from	ghr_pa_history
    where	pa_history_id = p_pa_history_id
    for	update nowait;