[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT
action_information4 pf_no
,action_information5 nssn
,action_information6 hire_date
,action_information7 emp_type
,action_information8 term_date
,action_information9 report_term_reason
,action_information10 efile_term_reason
,action_information11 eps
,action_information13 pf_class
,action_context_id assignment_action_id
FROM pay_action_information
WHERE action_information2 = p_pf_arc_ref_no
AND action_information1 = p_business_number
AND action_information3 = p_month||p_year
AND action_information_category = 'IN_PF_PERSON_DTLS'
AND action_context_type = 'AAP'
AND DECODE(action_information5,NULL,'NO_NSSN','NSSN') LIKE DECODE(p_nssn,'ALL','%',p_nssn)
ORDER BY (DECODE(p_sort_by,'NSSN',action_information5,'DOJ',action_information6));
SELECT action_information3 bal_name
,SUM (fnd_number.canonical_to_number(action_information4)) bal_value
FROM pay_action_information pai
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_SALARY'
AND action_context_type = 'AAP'
AND action_information5 = p_pf_class
GROUP BY action_information3;
SELECT SUM(fnd_number.canonical_to_number(action_information21)) Interest_on_Sec
,SUM(fnd_number.canonical_to_number(action_information22)) Legal_Charges
,SUM(fnd_number.canonical_to_number(action_information23)) Penalty
FROM (SELECT DISTINCT
action_information21
,action_information22
,action_information23
,action_information8
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_CHALLAN'
AND action_context_type = 'PA');
SELECT SUM(fnd_number.canonical_to_number(action_information7)) Payment_under_Protest
FROM (SELECT DISTINCT
action_information7
,action_information8
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_CHALLAN'
AND action_context_type = 'PA'
AND action_information20 = 'Y');
SELECT DISTINCT
action_information2 Payment_Type
,action_information4 Cheque_DD_No
,action_information5 Cheque_DD_Date
,action_information6 Cheque_DD_Dep_Date
,fnd_number.canonical_to_number(action_information7) Amount
,action_information8 Challan_Ref
,action_information9 Bank_Code
,hr_general.decode_lookup('IN_PF_BANKS',action_information9) Bank_Name
,action_information11 Branch_Code
,action_information12 Branch_Name
,action_information13 Branch_Add
,action_information14 Dep_Bank_Code
,action_information15 Dep_Branch_Code
,action_information16 Dep_Branch_Name
,action_information17 Dep_Branch_Address
,action_information18 Base_Branch_Code
,hr_general.decode_lookup('IN_PF_BASE_BRANCH',action_information18) Base_Branch_Name
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_CHALLAN'
AND action_context_type = 'PA';
SELECT DISTINCT
action_information8 Challan_Ref
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_CHALLAN'
AND action_context_type = 'PA';
SELECT DISTINCT
action_information1 Prev_Mth
,action_information2 Prev_Yr
,action_information3 Challan_Ref
,fnd_number.canonical_to_number(action_information4) Penal_Damages_Due
,fnd_number.canonical_to_number(action_information5) EPS_Penal_Damages
,fnd_number.canonical_to_number(action_information6) EDLI_Penal_Damages
,fnd_number.canonical_to_number(action_information7) EPF_Penal_Damages
,fnd_number.canonical_to_number(action_information8) Edli_Admin
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information3 = p_challan
AND action_information_category = 'IN_PF_14B'
AND action_context_type = 'PA';
SELECT DISTINCT
action_information8 Challan_Ref
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_CHALLAN'
AND action_context_type = 'PA';
SELECT DISTINCT
action_information1 Due_Mth
,action_information2 Due_Yr
,action_information3 Challan_Ref
,fnd_number.canonical_to_number(action_information4) EPF_Damages
,fnd_number.canonical_to_number(action_information5) EPS_Damages
,fnd_number.canonical_to_number(action_information6) EDLI_Damages
,fnd_number.canonical_to_number(action_information7) EPF_Admin
,fnd_number.canonical_to_number(action_information8) EDLI_Admin
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information3 = p_challan
AND action_information_category = 'IN_PF_7Q'
AND action_context_type = 'PA';
SELECT DISTINCT
action_information8 Challan_Ref
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_business_number
AND action_information_category = 'IN_PF_CHALLAN'
AND action_context_type = 'PA';
SELECT DISTINCT
fnd_number.canonical_to_number(action_information2) EPF_Misc_Pay
,action_information3 EPF_Rem
,fnd_number.canonical_to_number(action_information4) EPS_Misc_Pay
,action_information5 EPS_Rem
,fnd_number.canonical_to_number(action_information6) EDLI_Misc_Pay
,action_information7 EDLI_Rem
,fnd_number.canonical_to_number(action_information8) EPF_Admin
,action_information9 EPF_Admin_Rem
,fnd_number.canonical_to_number(action_information10) EDLI_Admin
,action_information11 EDLI_Admin_Rem
FROM pay_action_information
WHERE action_context_id = p_action_context_id
AND action_information1 = p_challan
AND action_information_category = 'IN_PF_MISC'
AND action_context_type = 'PA';
SELECT org_information1
FROM hr_organization_information
WHERE org_information2 = p_filer_license_no
AND org_information_context = 'PER_IN_COMPANY_FILER_INFO';
SELECT DISTINCT
action_information4 rep_name
,action_information5 rep_pos
FROM pay_action_information
WHERE action_information_category = 'IN_PF_ORG'
AND action_context_type = 'PA'
AND action_context_id = p_action_context_id
AND action_information1 = p_business_number ;
SELECT DISTINCT
action_information1 business_no
,action_information2 ref_no
,action_information3 mth_yr
,action_information4 return_type
,action_information5 reg_comp_name
,action_context_id action_context_id
FROM pay_action_information
WHERE action_information2 = p_pf_arc_ref_no
AND action_information1 = p_business_number
AND action_information3 = p_month||p_year
AND action_information_category = 'IN_PF_BUSINESS_NUMBER'
AND action_context_type = 'PA';
SELECT DISTINCT
action_information20 pup
FROM pay_action_information pai,
pay_payroll_actions ppa
WHERE pai.action_context_id = ppa.payroll_action_id
AND ppa.action_type = 'X'
AND ppa.action_status = 'C'
AND ppa.report_type ='IN_PF_ARCHIVE'
AND pai.action_context_id = p_action_context_id
AND pai.action_information1 = p_business_number
AND pai.action_information_category = 'IN_PF_CHALLAN'
AND pai.action_context_type = 'PA';
SELECT DISTINCT
pai.action_information1 bus_no
FROM pay_action_information pai,
pay_payroll_actions ppa
WHERE pai.action_context_id = ppa.payroll_action_id
AND ppa.action_type = 'X'
AND ppa.action_status = 'C'
AND ppa.report_type ='IN_PF_ARCHIVE'
AND pai.action_context_type = 'PA'
AND pai.action_information_category = 'IN_PF_BUSINESS_NUMBER'
AND pai.action_information1 = NVL(p_pf_business_no,pai.action_information1)
AND pai.action_information3 = p_yr_mth
AND pai.action_information2 = p_pf_arc_ref_no
AND ppa.business_group_id = g_bg_id;