[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select person_id from PER_ALL_ASSIGNMENTS_F
where ASSIGNMENT_ID = p_ASSIGNMENT_ID
and p_effective_date between EFFECTIVE_START_DATE and nvl(EFFECTIVE_end_DATE,p_effective_date );
select to_number(nvl(pcr.CONT_INFORMATION5,0))
from per_contact_relationships pcr,
per_all_people_f paf
where paf.PERSON_ID = p_PERSON_ID
and pcr.person_id = paf.person_id
and pcr.CONT_INFORMATION1 = 'N'
and pcr.CONT_INFORMATION4 = 'Y'
and pcr.CONT_INFORMATION6 is NULL
and pcr.CONT_information_category ='DE_PQH'
and pcr.contact_type = 'S'
and paf.business_group_id = p_business_group_id
and pcr.business_group_id = p_business_group_id
and p_effective_date between paf.EFFECTIVE_START_DATE and nvl( paf.EFFECTIVE_end_DATE,p_effective_date ) ;
select to_number(nvl(pcr.CONT_INFORMATION6,0)) count1
from per_contact_relationships pcr,
per_all_people_f paf
where paf.PERSON_ID = p_PERSON_ID
and pcr.person_id = paf.person_id
and pcr.CONT_INFORMATION1 = 'N'
and pcr.CONT_INFORMATION4 = 'Y'
and pcr.CONT_INFORMATION6 is not NULL
and pcr.CONT_information_category ='DE_PQH'
and pcr.contact_type in ('A','O','OC','T')
and paf.business_group_id = p_business_group_id
and pcr.business_group_id = p_business_group_id
and p_effective_date between paf.EFFECTIVE_START_DATE and nvl( paf.EFFECTIVE_end_DATE ,p_effective_date )
ORDER BY COUNT1 ASC;
select NVL(marital_status,'S') from per_all_people_f
where PERSON_ID = p_PERSON_ID
and business_group_id = p_business_group_id
AND p_effective_date between EFFECTIVE_START_DATE and nvl( EFFECTIVE_end_DATE,p_effective_date) ;
select grade_id from per_grades
where name = p_pay_grade
and business_group_id = p_business_group_id
and p_effective_date between DATE_from and nvl(DATE_to,p_effective_date ) ;
select
pghn.information1, -- Additional amount First Child
pghn.information2, -- Additional amount Second Child
pghn.information3, -- Additional amount Further Child
pghn.information4, -- Amount if Single
pghn.information5, -- Amount if Married
pghn.information6 -- Amount if Married and a child
from per_gen_hierarchy_nodes pghn,
per_gen_hierarchy_versions pghv,
per_gen_hierarchy_nodes pghn1,
per_gen_hierarchy_nodes pghn2,
per_gen_hierarchy pgh
where pgh.TYPE='LOCAL_COST_OF_LIVING'
and pghv.HIERARCHY_ID=pgh.HIERARCHY_ID
and pghn.HIERARCHY_VERSION_ID=pghv.HIERARCHY_VERSION_ID
and p_effective_date between pghv.date_from and nvl(pghv.date_to, p_effective_date)
and pghn.NODE_TYPE ='TARIFF_CLASS'
and pghn2.NODE_TYPE ='LCOL_PAY_GRADES'
and pghn1.NODE_TYPE ='TARIFF_GROUP'
and pghn1.entity_id = p_tariff_group
and pghn2.entity_id = l_grade_id
and pghn1.PARENT_HIERARCHY_NODE_ID = pghn.HIERARCHY_NODE_ID
and pghn2.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID;