[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
FROM hr_organization_information ch_b
, hr_organization_information it_ch
WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
AND it_ch.organization_id = p_gre_org_id
AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(p_assess_year,1,4)) - 1)||'-'||SUBSTR(p_assess_year,1,4))
AND it_ch.organization_id = ch_b.organization_id
AND TO_NUMBER(it_ch.org_information5) = ch_b.org_information_id;
SELECT COUNT(*)
FROM pay_action_information
WHERE action_information_category = 'IN_EOY_PERSON'
AND action_context_type = 'AAP'
AND action_information2 = p_assess_year
AND action_information3 = p_gre_org_id
AND action_context_id IN ( SELECT MAX(pai.action_context_id)
FROM pay_action_information pai
,pay_assignment_actions paa
,per_assignments_f asg
WHERE pai.action_information_category = 'IN_EOY_PERSON'
AND pai.action_context_type = 'AAP'
AND pai.assignment_id = asg.assignment_id
AND paa.assignment_id = asg.assignment_id
AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND pai.action_information2 = p_assess_year
AND pai.action_information3 = p_gre_org_id
AND pai.source_id = paa.assignment_action_id
GROUP BY pai.action_information1,pai.action_information17 );
SELECT COUNT(*)
FROM pay_action_information
WHERE action_information_category = 'IN_EOY_PERSON'
AND action_context_type = 'AAP'
AND action_information2 = p_assess_year
AND action_information3 = p_gre_org_id
AND action_context_id IN ( SELECT MAX(pai.action_context_id)
FROM pay_action_information pai
,pay_assignment_actions paa
,per_assignments_f asg
WHERE pai.action_information_category = 'IN_EOY_PERSON'
AND pai.action_context_type = 'AAP'
AND pai.assignment_id = asg.assignment_id
AND paa.assignment_id = asg.assignment_id
AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND pai.action_information2 = p_assess_year
AND pai.action_information3 = p_gre_org_id
AND pai.source_id = paa.assignment_action_id
GROUP BY pai.action_information1,pai.action_information17 );
SELECT SUM(NVL(it_ch.org_information4,0)) TDS
, SUM(NVL(it_ch.org_information7,0)) SUR
, SUM(NVL(it_ch.org_information8,0)) EC
, SUM(NVL(it_ch.org_information9,0)) INTR
, SUM(NVL(it_ch.org_information10,0)) OTH
FROM hr_organization_information ch_b
, hr_organization_information it_ch
WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
AND it_ch.organization_id = p_gre_org_id
AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(p_assess_year,1,4)) - 1)||'-'||SUBSTR(p_assess_year,1,4))
AND it_ch.organization_id = ch_b.organization_id
AND TO_NUMBER(it_ch.org_information5) = ch_b.org_information_id;
SELECT NVL(SUM(action_information2),0)
FROM pay_action_information
WHERE action_information_category = 'IN_EOY_ASG_SAL'
AND action_context_type = 'AAP'
AND action_information1 = p_balance
AND action_context_id = p_action_context_id
AND source_id = p_source_id;
SELECT MAX(pai.action_context_id) action_cont_id
,source_id sour_id
FROM pay_action_information pai
,pay_assignment_actions paa
,per_assignments_f asg
WHERE pai.action_information_category = 'IN_EOY_PERSON'
AND pai.assignment_id = asg.assignment_id
AND paa.assignment_id = asg.assignment_id
AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND pai.action_information3 = p_gre_org_id
AND pai.action_information2 = p_assess_year
AND pai.action_context_type = 'AAP'
AND pai.source_id = paa.assignment_action_id
GROUP BY pai.action_information1,pai.action_information17,source_id;
SELECT NVL(action_information2,'0')
,NVL(action_information3,'0')
,NVL(action_information4,'0')
,NVL(action_information5,'0')
FROM pay_action_information
WHERE action_information_category = p_category
AND action_information1 = p_component_name
AND action_context_id = p_context_id
AND source_id = p_source_id;
SELECT paei.aei_information2
FROM per_assignment_extra_info paei
,per_all_assignments_f paa
WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
AND paei.assignment_id = paa.assignment_id
AND paa.person_id = TO_NUMBER(p_person_id)
AND paei.aei_information1 = TO_CHAR((TO_NUMBER(SUBSTR(p_assess_year,1,4)) - 1)||'-'||SUBSTR(p_assess_year,1,4))
AND fnd_date.CHARDATE_TO_DATE(p_date) BETWEEN paa.effective_start_date AND paa.effective_end_date
AND ROWNUM = 1;
SELECT org_information3
FROM hr_organization_information
WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
AND organization_id = p_gre_org_id;
SELECT address_line_1,
NVL(address_line_2,' '),
NVL(address_line_3,' '),
NVL(loc_information14,' '),
loc_information15,
NVL(hr_general.decode_lookup('IN_STATE_CODES',loc_information16),' '),
NVL(postal_code,' ')
FROM hr_locations
WHERE location_id = p_location_id;