APPS.PSP_PSPENASG_XMLP_PKG SQL Statements

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

Line: 6

	SELECT 	meaning
	FROM	fnd_lookups
	WHERE	lookup_type = 'PSP_ENC_CHANGE_SOURCE'
	AND	lookup_code =  change_type;

Line: 32

	SELECT	name
	FROM		hr_all_organization_units
	WHERE		organization_id = reference_id;

Line: 37

	SELECT	hrou.name
	FROM		hr_all_organization_units hrou,
					Psp_organization_accounts poa
	WHERE		poa.organization_id = hrou.organization_id
	AND			poa.organization_account_id = reference_id;

Line: 44

	SELECT	hrou.name
	FROM		hr_all_organization_units hrou,
					Psp_enc_end_dates peed
	WHERE		peed.organization_id = hrou.organization_id
	AND		peed.enc_end_date_id = reference_id;

Line: 52

	SELECT hou.name
	FROM	hr_all_organization_units hou,
		per_all_assignments_f paf
	WHERE	paf.assignment_id =assignment_id
	AND	paf.organization_id= hou.organization_id
	AND	sysdate between paf.effective_start_date and paf.effective_end_date;

Line: 62

	SELECT	hrou.name
	FROM		hr_all_organization_units hrou,
					psp_default_labor_schedules pdls
	WHERE		pdls.organization_id = hrou.organization_id
	AND		pdls.org_schedule_id = reference_id;

Line: 70

SELECT hou.name
FROM	hr_organization_units hou ,
	psp_enc_changed_sch_history pecsh
WHERE  hou.organization_id = pecsh.reference_id
AND  	pecsh.request_id = p_request_id
AND 	pecsh.change_type = 'GS'
AND 	pecsh.action_type ='G' ;

Line: 139

	SELECT	element_name
	FROM		pay_element_types_f petf
	WHERE		element_type_id = reference_id
	AND ( trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
  OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1
where petf1.element_type_id= petf.element_type_id)));

Line: 147

	SELECT	pet.element_name
	FROM		pay_element_types_f pet,
					Psp_element_type_accounts peta
	WHERE		pet.element_type_id = peta.element_type_id
	AND			Peta.element_account_id = reference_id
	AND ( trunc(sysdate) BETWEEN pet.effective_start_date AND
pet.effective_end_date
 OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1
where petf1.element_type_id= pet.element_type_id)));

Line: 159

	SELECT	 pet.element_name
	FROM 	 pay_element_types_f  pet,
	psp_enc_lines_history pelh
	WHERE
	pelh.element_account_id= reference_id
	AND 	pelh.enc_element_type_id= pet.element_type_id
	AND	rownum=1 ;