[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TO_CHAR(COUNT(*) + 1)
FROM hr_organization_information
WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
AND org_information1 = p_assess_year
AND org_information2 = p_quarter
AND org_information6 = 'C'
AND organization_id = p_gre_org_id;
SELECT COUNT(DISTINCT action_information1)
FROM pay_action_information pai
WHERE action_information_category = 'IN_24QC_CHALLAN'
AND action_context_type = 'PA'
AND action_information3 = p_gre_org_id
AND action_information2 = p_assess_period
AND pai.action_context_id= p_max_action_id
AND fnd_date.canonical_to_date(pai.action_information5) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
AND action_information29 LIKE '%' || p_correction_type || '%';
SELECT org_information4
,org_information3
FROM hr_organization_information
WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
AND org_information1 = p_assess_year
AND org_information2 = p_quarter
AND org_information6 ='O'
AND organization_id = p_gre_org_id
ORDER BY org_information3 ASC;
SELECT org_information4
,org_information3
FROM hr_organization_information
WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
AND org_information1 = p_assess_year
AND org_information2 = p_quarter
AND organization_id = p_gre_org_id
ORDER BY org_information3 DESC;
SELECT SUM (TDS)
, SUM (SUR)
, SUM (EC)
, SUM (INTR)
, SUM (OTH)
FROM ( SELECT DISTINCT pai.action_information1
, NVL(pai.action_information6,0) TDS
, NVL(pai.action_information7,0) SUR
, NVL(pai.action_information8,0) EC
, NVL(pai.action_information9,0) INTR
, NVL(pai.action_information10,0) OTH
FROM pay_action_information pai
WHERE action_information_category = 'IN_24QC_CHALLAN'
AND action_context_type = 'PA'
AND action_information3 = p_gre_org_id
AND action_information2 = p_assess_period
AND pai.action_context_id = p_max_action_id
AND NVL(pai.action_information18, 'NC') <> 'NC'
AND pai.action_information29 like '%'||p_correction_type||'%'
AND fnd_date.canonical_to_date(pai.action_information5) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
);
SELECT action_information25
FROM pay_action_information pai
WHERE action_information_category = 'IN_24QC_ORG'
AND action_context_type = 'PA'
AND pai.action_information1 = p_gre_org_id
AND pai.action_information3 = p_assess_period
AND pai.action_context_id = p_max_action_id;
SELECT COUNT(DISTINCT source_id)
FROM pay_action_information pai
WHERE action_information_category = 'IN_24QC_DEDUCTEE'
AND action_context_type = 'AAP'
AND action_information3 = p_gre_org_id
AND EXISTS (SELECT 1
FROM pay_assignment_actions paa
WHERE paa.payroll_action_id = p_max_action_id
AND paa.assignment_action_id = pai.action_context_id)
AND pai.action_information1 = p_challan;
SELECT SUM(DECODE(action_information15, 'D', -1 * NVL(action_information16, 0)
, NVL(action_information16, 0)))
- SUM(DECODE(action_information15, 'U', NVL(action_information24, 0)
, 0)) tax_deposited
,SUM(DECODE(action_information15, 'D', -1 * NVL(action_information6, 0)
, NVL(action_information6, 0)))
- SUM(DECODE(action_information15, 'U', NVL(action_information21, 0)
, 0)) tds
,SUM(DECODE(action_information15, 'D', -1 * NVL(action_information7, 0)
, NVL(action_information7, 0)))
- SUM(DECODE(action_information15, 'U', NVL(action_information22, 0)
, 0)) surcharge
,SUM(DECODE(action_information15, 'D', -1 * NVL(action_information8, 0)
, NVL(action_information8, 0)))
- SUM(DECODE(action_information15, 'U', NVL(action_information23, 0)
, 0)) cess
FROM (
SELECT DISTINCT source_id
,pay_in_24qc_er_returns.remove_curr_format(action_information15) action_information15
,pay_in_24qc_er_returns.remove_curr_format(action_information16) action_information16
,pay_in_24qc_er_returns.remove_curr_format(action_information24) action_information24
,pay_in_24qc_er_returns.remove_curr_format(action_information6) action_information6
,pay_in_24qc_er_returns.remove_curr_format(action_information21) action_information21
,pay_in_24qc_er_returns.remove_curr_format(action_information7) action_information7
,pay_in_24qc_er_returns.remove_curr_format(action_information22) action_information22
,pay_in_24qc_er_returns.remove_curr_format(action_information8) action_information8
,pay_in_24qc_er_returns.remove_curr_format(action_information23) action_information23
FROM pay_action_information
WHERE action_information_category ='IN_24QC_DEDUCTEE'
AND action_context_type = 'AAP'
AND action_information3 = p_gre_org_id
AND action_information1 = p_challan_number
AND INSTR(NVL(action_information19,'0'),'C5') = 0
AND EXISTS ( SELECT 1
FROM pay_assignment_actions paa
WHERE paa.payroll_action_id = p_max_action_id
AND paa.assignment_action_id = action_context_id));
SELECT MAX(action_context_id)
FROM pay_action_information
WHERE action_information1 = p_gre_org_id
AND action_information3 = p_period
AND action_context_type = 'PA'
AND action_information_category = 'IN_24QC_ORG';
SELECT NVL(SUM(action_information2),0)
FROM pay_action_information
WHERE action_information_category = 'IN_24QC_SALARY'
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 paa.payroll_action_id = p_max_action_id
AND pai.action_context_id = paa.assignment_action_id
AND pai.action_information_category = 'IN_24QC_PERSON'
AND pai.action_information3 = p_gre_org_id
AND pai.action_information2 = p_assess_period
AND pai.action_information1 = asg.person_id
AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND asg.assignment_id = pai.assignment_id
AND pai.action_context_type = 'AAP'
AND pai.action_information11 = 'C4'
GROUP BY pai.action_information1,pai.action_information9,source_id;
SELECT COUNT(*)
FROM pay_action_information
WHERE action_information_category = 'IN_24QC_PERSON'
AND action_context_type = 'AAP'
AND action_information2 = p_assess_period
AND action_information3 = p_gre_org_id
AND action_information11 = p_correction_type
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 paa.payroll_action_id = p_max_action_id
AND pai.action_context_id = paa.assignment_action_id
AND pai.action_information_category = 'IN_24QC_PERSON'
AND pai.action_context_type = 'AAP'
AND pai.action_information1 = asg.person_id
AND pai.assignment_id = asg.assignment_id
AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND pai.action_information2 = p_assess_period
AND pai.action_information3 = p_gre_org_id
AND pai.action_information11 = p_correction_type
GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9
);
SELECT COUNT(*)
FROM pay_action_information
WHERE action_information_category = 'IN_24QC_VIA'
AND action_context_type = 'AAP'
AND action_context_id = p_action_context_id
AND source_id =p_source_id;