eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24QC_ARCHIVE dependencies on FND_DATE

Line 506: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');

502: g_old_format := 'N';
503: END IF;
504:
505: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
506: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
507: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
508:
509: g_qr_start_date := ADD_MONTHS(l_assess_yr_start,(i*3)-12);
510: g_end_date := ADD_MONTHS(g_qr_start_date,3) -1;

Line 507: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');

503: END IF;
504:
505: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
506: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
507: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
508:
509: g_qr_start_date := ADD_MONTHS(l_assess_yr_start,(i*3)-12);
510: g_end_date := ADD_MONTHS(g_qr_start_date,3) -1;
511:

Line 614: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))

610: RETURN DATE
611: IS
612: CURSOR c_termination_check
613: IS
614: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
615: FROM per_all_assignments_f asg
616: ,per_periods_of_service pos
617: WHERE asg.person_id = pos.person_id
618: AND asg.assignment_id = p_assignment_id

Line 1042: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

1038: )
1039: )
1040: )
1041: AND pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
1042: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1043: FROM hr_organization_units hou
1044: ,hr_organization_information hoi
1045: ,hr_organization_information bank
1046: WHERE hoi.organization_id = hou.organization_id

Line 1056: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

1052: AND hoi.org_information5 = bank.org_information_id
1053: AND hoi.org_information13 = g_quarter
1054: AND hoi.organization_id = g_gre_id
1055: UNION
1056: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1057: FROM hr_organization_units hou
1058: ,hr_organization_information hoi
1059: WHERE hoi.organization_id = hou.organization_id
1060: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1082: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

1078: AND action_information_category = 'IN_24QC_CHALLAN'
1079: AND action_information2 = g_year||g_quarter
1080: AND action_information15 IN
1081: (
1082: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1083: FROM hr_organization_units hou
1084: ,hr_organization_information hoi
1085: ,hr_organization_information bank
1086: WHERE hoi.organization_id = hou.organization_id

Line 1096: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

1092: AND hoi.org_information5 = bank.org_information_id
1093: AND hoi.org_information13 = g_quarter
1094: AND hoi.organization_id = g_gre_id
1095: UNION
1096: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1097: FROM hr_organization_units hou
1098: ,hr_organization_information hoi
1099: WHERE hoi.organization_id = hou.organization_id
1100: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1129: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

1125: action_information15 = p_payroll_action_id
1126: AND action_information_category = 'IN_24QC_CHALLAN'
1127: AND action_information2 = g_year||g_quarter
1128: AND action_information15 IN
1129: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1130: FROM hr_organization_units hou
1131: ,hr_organization_information hoi
1132: ,hr_organization_information bank
1133: WHERE hoi.organization_id = hou.organization_id

Line 1143: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3

1139: AND hoi.org_information5 = bank.org_information_id
1140: AND hoi.org_information13 = g_quarter
1141: AND hoi.organization_id = g_gre_id
1142: UNION
1143: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1144: FROM hr_organization_units hou
1145: ,hr_organization_information hoi
1146: WHERE hoi.organization_id = hou.organization_id
1147: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 2913: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

2909: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2910: AND pep.person_id = hoi.org_information1
2911: AND pep.business_group_id = hou.business_group_id
2912: AND g_qr_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2913: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2914: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2915: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2916:
2917: CURSOR c_rep_phone(p_person_id NUMBER)

Line 2914: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))

2910: AND pep.person_id = hoi.org_information1
2911: AND pep.business_group_id = hou.business_group_id
2912: AND g_qr_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date
2913: AND g_qr_end_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)
2914: AND NVL(fnd_date.canonical_to_date(hoi.org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'))
2915: AND g_qr_end_date BETWEEN hou.date_from AND NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2916:
2917: CURSOR c_rep_phone(p_person_id NUMBER)
2918: IS

Line 3730: FOR csr_record IN c_challan_24q_data('IN_24Q_CHALLAN',NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ,NULL)

3726: l_dummy_boolean := TRUE;
3727: l_dummy := NULL;
3728:
3729:
3730: FOR csr_record IN c_challan_24q_data('IN_24Q_CHALLAN',NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ,NULL)
3731: LOOP
3732:
3733: IF (l_dummy_boolean)
3734: THEN

Line 3767: FOR csr_record IN c_challan_24q_data('IN_24QC_CHALLAN',NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ,NULL)

3763: -- need to check in Form 24Q Correction, firstly on the basis of
3764: -- Challan Number and then on basis of org_information_id
3765: pay_in_utils.set_location(g_debug,'Again opened',3);
3766: l_dummy_boolean := TRUE;
3767: FOR csr_record IN c_challan_24q_data('IN_24QC_CHALLAN',NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ,NULL)
3768: LOOP
3769: IF (l_dummy_boolean)
3770: THEN
3771: l_dummy := csr_record.transfer_voucher_number;

Line 3801: g_challan_data_add(g_count_challan_add).transfer_voucher_number := NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ;

3797: IF (l_dummy IS NULL)
3798: THEN
3799: --This means that in Form 24Q Correction, this record was never
3800: -- present. So need to insert this record data in PL/SQL table.
3801: g_challan_data_add(g_count_challan_add).transfer_voucher_number := NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ;
3802: g_challan_data_add(g_count_challan_add).transfer_voucher_date := c_rec.transfer_voucher_date;
3803: g_challan_data_add(g_count_challan_add).amount := c_rec.amount;
3804: g_challan_data_add(g_count_challan_add).surcharge := c_rec.surcharge;
3805: g_challan_data_add(g_count_challan_add).education_cess := c_rec.education_cess;

Line 3845: (c_rec.transfer_voucher_number <> NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR') ) OR

3841: pay_in_utils.set_location(g_debug,'Fetching Live Data ' ,2);
3842:
3843:
3844: IF (--24Q Archival Data Here Live Data Here
3845: (c_rec.transfer_voucher_number <> NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR') ) OR
3846: (c_rec.bank_branch_code <> l_bank_branch_code) OR
3847: (c_rec.transfer_voucher_date <> l_transfer_voucher_date) OR
3848: (c_rec.amount <> l_amount) OR
3849: (c_rec.surcharge <> l_surcharge) OR

Line 3883: (NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR') <> l_transfer_voucher_number_1) OR

3879: -- If not, then store in PL/SQL on the basis of 24Q Archival
3880: IF (l_action_information_id IS NOT NULL)
3881: THEN
3882: IF (-- Live Data here --24Q Correction Data here
3883: (NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR') <> l_transfer_voucher_number_1) OR
3884: (l_bank_branch_code <> l_bank_branch_code_1) OR
3885: (l_transfer_voucher_date <> l_transfer_voucher_date_1) OR
3886: (l_amount <> l_amount_1) OR
3887: (l_surcharge <> l_surcharge_1) OR

Line 3958: (NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR') <> l_transfer_voucher_number_1) OR

3954: -- This means that there is a reporting of this data in 24Q Correction. Now, need
3955: -- to check the diff of the two records. If diff exists then store this record
3956: -- on the basis of 24Q Correction else reject it.
3957: IF (--Live Data 24Q Correction Data
3958: (NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR') <> l_transfer_voucher_number_1) OR
3959: (l_bank_branch_code <> l_bank_branch_code_1) OR
3960: (l_transfer_voucher_date <> l_transfer_voucher_date_1) OR
3961: (l_amount <> l_amount_1) OR
3962: (l_surcharge <> l_surcharge_1) OR

Line 4566: ,fnd_date.canonical_to_date(pai.action_information9) start_date

4562: pai.action_information1 person_id
4563: ,pai.action_information4 pan_number
4564: ,pai.action_information5 pan_ref_number
4565: ,pai.action_information6 full_name
4566: ,fnd_date.canonical_to_date(pai.action_information9) start_date
4567: ,fnd_date.canonical_to_date(pai.action_information10) end_date
4568: ,pai.source_id
4569: FROM pay_action_information pai
4570: ,pay_assignment_actions paa

Line 4567: ,fnd_date.canonical_to_date(pai.action_information10) end_date

4563: ,pai.action_information4 pan_number
4564: ,pai.action_information5 pan_ref_number
4565: ,pai.action_information6 full_name
4566: ,fnd_date.canonical_to_date(pai.action_information9) start_date
4567: ,fnd_date.canonical_to_date(pai.action_information10) end_date
4568: ,pai.source_id
4569: FROM pay_action_information pai
4570: ,pay_assignment_actions paa
4571: WHERE pai.action_information_category IN('IN_24Q_PERSON')

Line 4590: ,fnd_date.canonical_to_date(pai.action_information8) start_date

4586: pai.action_information1 person_id
4587: ,pai.action_information4 pan_number
4588: ,pai.action_information5 pan_ref_number
4589: ,pai.action_information6 full_name
4590: ,fnd_date.canonical_to_date(pai.action_information8) start_date
4591: ,fnd_date.canonical_to_date(pai.action_information9) end_date
4592: ,pai.source_id
4593: FROM pay_action_information pai
4594: ,pay_assignment_actions paa

Line 4591: ,fnd_date.canonical_to_date(pai.action_information9) end_date

4587: ,pai.action_information4 pan_number
4588: ,pai.action_information5 pan_ref_number
4589: ,pai.action_information6 full_name
4590: ,fnd_date.canonical_to_date(pai.action_information8) start_date
4591: ,fnd_date.canonical_to_date(pai.action_information9) end_date
4592: ,pai.source_id
4593: FROM pay_action_information pai
4594: ,pay_assignment_actions paa
4595: ,pay_action_interlocks locks

Line 4758: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))

4754: AND ROWNUM =1;
4755:
4756: CURSOR c_termination_check(p_assignment_id NUMBER)
4757: IS
4758: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
4759: FROM per_all_assignments_f asg
4760: ,per_periods_of_service pos
4761: WHERE asg.person_id = pos.person_id
4762: AND asg.assignment_id = p_assignment_id

Line 5628: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5624: ,p_action_information4 => tab_liv_pe_data.pan_number
5625: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5626: ,p_action_information6 => tab_liv_pe_data.full_name
5627: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5628: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5629: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5630: ,p_action_information10 => 'D'
5631: ,p_action_information11 => 'C4'
5632: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 5629: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5625: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5626: ,p_action_information6 => tab_liv_pe_data.full_name
5627: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5628: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5629: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5630: ,p_action_information10 => 'D'
5631: ,p_action_information11 => 'C4'
5632: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
5633: ,p_action_information_id => l_action_info_id

Line 5733: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5729: ,p_action_information4 => tab_liv_pe_data.pan_number
5730: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5731: ,p_action_information6 => tab_liv_pe_data.full_name
5732: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5733: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5734: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5735: ,p_action_information10 => 'A'
5736: ,p_action_information11 => 'C4'
5737: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s

Line 5734: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5730: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5731: ,p_action_information6 => tab_liv_pe_data.full_name
5732: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5733: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5734: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5735: ,p_action_information10 => 'A'
5736: ,p_action_information11 => 'C4'
5737: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s
5738: ,p_action_information_id => l_action_info_id

Line 5807: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

5803: ,p_action_information4 => tab_liv_pe_data.pan_number
5804: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5805: ,p_action_information6 => tab_liv_pe_data.full_name
5806: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5807: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5808: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5809: ,p_action_information10 => 'NA'
5810: ,p_action_information11 => 'C5'
5811: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 5808: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

5804: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
5805: ,p_action_information6 => tab_liv_pe_data.full_name
5806: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
5807: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
5808: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
5809: ,p_action_information10 => 'NA'
5810: ,p_action_information11 => 'C5'
5811: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
5812: ,p_action_information_id => l_action_info_id

Line 6011: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6007: ,p_action_information4 => tab_liv_pe_data.pan_number
6008: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6009: ,p_action_information6 => tab_liv_pe_data.full_name
6010: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6011: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6012: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6013: ,p_action_information10 => 'NA'
6014: ,p_action_information11 => 'C5'
6015: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 6012: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6008: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6009: ,p_action_information6 => tab_liv_pe_data.full_name
6010: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6011: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6012: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6013: ,p_action_information10 => 'NA'
6014: ,p_action_information11 => 'C5'
6015: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
6016: ,p_action_information_id => l_action_info_id

Line 6073: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6069: ,p_action_information4 => tab_liv_pe_data.pan_number
6070: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6071: ,p_action_information6 => tab_liv_pe_data.full_name
6072: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6073: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6074: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6075: ,p_action_information10 => 'A'
6076: ,p_action_information11 => 'C4'
6077: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s

Line 6074: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6070: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6071: ,p_action_information6 => tab_liv_pe_data.full_name
6072: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6073: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6074: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6075: ,p_action_information10 => 'A'
6076: ,p_action_information11 => 'C4'
6077: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s
6078: ,p_action_information_id => l_action_info_id

Line 6180: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6176: ,p_action_information4 => tab_liv_pe_data.pan_number
6177: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6178: ,p_action_information6 => tab_liv_pe_data.full_name
6179: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6180: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6181: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6182: ,p_action_information10 => 'D'
6183: ,p_action_information11 => 'C4'
6184: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 6181: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6177: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6178: ,p_action_information6 => tab_liv_pe_data.full_name
6179: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6180: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6181: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6182: ,p_action_information10 => 'D'
6183: ,p_action_information11 => 'C4'
6184: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
6185: ,p_action_information_id => l_action_info_id

Line 6385: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6381: ,p_action_information4 => tab_liv_pe_data.pan_number
6382: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6383: ,p_action_information6 => tab_liv_pe_data.full_name
6384: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6385: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6386: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6387: ,p_action_information10 => 'NA'
6388: ,p_action_information11 => 'C5'
6389: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 6386: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6382: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6383: ,p_action_information6 => tab_liv_pe_data.full_name
6384: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6385: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6386: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6387: ,p_action_information10 => 'NA'
6388: ,p_action_information11 => 'C5'
6389: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
6390: ,p_action_information_id => l_action_info_id

Line 6435: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6431: ,p_action_information4 => tab_liv_pe_data.pan_number
6432: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6433: ,p_action_information6 => tab_liv_pe_data.full_name
6434: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6435: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6436: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6437: ,p_action_information10 => 'D'
6438: ,p_action_information11 => 'C4'
6439: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))

Line 6436: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6432: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6433: ,p_action_information6 => tab_liv_pe_data.full_name
6434: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6435: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6436: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6437: ,p_action_information10 => 'D'
6438: ,p_action_information11 => 'C4'
6439: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0))
6440: ,p_action_information_id => l_action_info_id

Line 6527: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)

6523: ,p_action_information4 => tab_liv_pe_data.pan_number
6524: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6525: ,p_action_information6 => tab_liv_pe_data.full_name
6526: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6527: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6528: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6529: ,p_action_information10 => 'A'
6530: ,p_action_information11 => 'C4'
6531: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s

Line 6528: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)

6524: ,p_action_information5 => tab_liv_pe_data.pan_ref_number
6525: ,p_action_information6 => tab_liv_pe_data.full_name
6526: ,p_action_information7 => pay_in_24q_er_returns.get_emp_category(tab_liv_pe_data.person_id)
6527: ,p_action_information8 => fnd_date.date_to_canonical(tab_liv_pe_data.start_date)
6528: ,p_action_information9 => fnd_date.date_to_canonical(tab_liv_pe_data.end_date)
6529: ,p_action_information10 => 'A'
6530: ,p_action_information11 => 'C4'
6531: ,p_action_information12 => GREATEST(NVL(j,0),NVL(k,0)) + s
6532: ,p_action_information_id => l_action_info_id

Line 7194: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number

7190: FROM pay_action_information
7191: WHERE action_context_type = 'PA'
7192: AND action_information_category = 'IN_24QC_CHALLAN'
7193: AND action_information15 = p_24qa_pay_act_id
7194: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number
7195: AND action_context_id IN(
7196: SELECT org_information3
7197: FROM hr_organization_information
7198: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'

Line 7221: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number

7217: FROM pay_action_information pai
7218: WHERE pai.action_context_type = 'PA'
7219: AND pai.action_information_category = 'IN_24Q_CHALLAN'
7220: AND pai.action_context_id = p_24qa_pay_act_id
7221: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number
7222: ORDER BY action_information_id DESC;
7223:
7224: CURSOR c_populate_no_change_data
7225: IS

Line 7279: IF( (g_challan_data_add(i).transfer_voucher_number = NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') )

7275: pay_in_utils.set_location(g_debug,'Checking in Added Challans ', 1);
7276: -- Checking in Added Challans
7277: FOR i IN 1..g_count_challan_add - 1
7278: LOOP
7279: IF( (g_challan_data_add(i).transfer_voucher_number = NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') )
7280: OR
7281: (g_challan_data_add(i).org_information_id = c_rec.org_information_id)
7282: )
7283: THEN

Line 7291: IF ((g_challan_data_upd(i).transfer_voucher_number = NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') )

7287:
7288: pay_in_utils.set_location(g_debug,'Checking in Updated Challans ', 1);
7289: FOR i IN 1..g_count_challan_upd - 1
7290: LOOP
7291: IF ((g_challan_data_upd(i).transfer_voucher_number = NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') )
7292: OR
7293: (g_challan_data_upd(i).org_information_id = c_rec.org_information_id)
7294: )
7295: THEN

Line 7302: g_challan_data_noc(g_count_challan_noc).transfer_voucher_number := NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ;

7298: END LOOP;
7299: --Insert Record in PL/SQL Table for no change Challans
7300: IF (l_flag)
7301: THEN
7302: g_challan_data_noc(g_count_challan_noc).transfer_voucher_number := NVL(c_rec.bank_branch_code,'BOOK')||' - '||c_rec.challan_number||' - '||to_char(fnd_date.canonical_to_date(c_rec.transfer_voucher_date),'DD-Mon-RRRR') ;
7303: g_challan_data_noc(g_count_challan_noc).transfer_voucher_date := c_rec.transfer_voucher_date;
7304: g_challan_data_noc(g_count_challan_noc).amount := c_rec.amount;
7305: g_challan_data_noc(g_count_challan_noc).surcharge := c_rec.surcharge;
7306: g_challan_data_noc(g_count_challan_noc).education_cess := c_rec.education_cess;

Line 7689: ,p_action_information1 => NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR')

7685: (p_action_context_id => p_24qc_pay_act_id
7686: ,p_action_context_type => 'PA'
7687: ,p_action_information_category => 'IN_24QC_CHALLAN'
7688: ,p_source_id => l_org_information_id
7689: ,p_action_information1 => NVL(l_bank_branch_code,'BOOK')||' - '||l_transfer_voucher_number||' - '||to_char(fnd_date.canonical_to_date(l_transfer_voucher_date),'DD-Mon-RRRR')
7690: ,p_action_information2 => g_year||g_quarter
7691: ,p_action_information3 => g_gre_id
7692: ,p_action_information4 => l_bank_branch_code
7693: ,p_action_information5 => l_transfer_voucher_date