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_ER_RETURNS dependencies on PAY_MAGTAPE_GENERIC

Line 7: g_gre_org_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM');

3:
4: level_cnt NUMBER;
5:
6:
7: g_gre_org_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM');
8: g_assess_year VARCHAR2(15) := pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM');
9: g_quarter VARCHAR2(15) := pay_magtape_generic.get_parameter_value('QUARTER_PARAM');
10: g_action_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REF_PARAM');
11: g_salary_detail VARCHAR2(5):= pay_magtape_generic.get_parameter_value('SAL_DET_PARAM');

Line 8: g_assess_year VARCHAR2(15) := pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM');

4: level_cnt NUMBER;
5:
6:
7: g_gre_org_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM');
8: g_assess_year VARCHAR2(15) := pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM');
9: g_quarter VARCHAR2(15) := pay_magtape_generic.get_parameter_value('QUARTER_PARAM');
10: g_action_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REF_PARAM');
11: g_salary_detail VARCHAR2(5):= pay_magtape_generic.get_parameter_value('SAL_DET_PARAM');
12:

Line 9: g_quarter VARCHAR2(15) := pay_magtape_generic.get_parameter_value('QUARTER_PARAM');

5:
6:
7: g_gre_org_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM');
8: g_assess_year VARCHAR2(15) := pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM');
9: g_quarter VARCHAR2(15) := pay_magtape_generic.get_parameter_value('QUARTER_PARAM');
10: g_action_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REF_PARAM');
11: g_salary_detail VARCHAR2(5):= pay_magtape_generic.get_parameter_value('SAL_DET_PARAM');
12:
13: --------------------------------------------------------------------------

Line 10: g_action_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REF_PARAM');

6:
7: g_gre_org_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM');
8: g_assess_year VARCHAR2(15) := pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM');
9: g_quarter VARCHAR2(15) := pay_magtape_generic.get_parameter_value('QUARTER_PARAM');
10: g_action_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REF_PARAM');
11: g_salary_detail VARCHAR2(5):= pay_magtape_generic.get_parameter_value('SAL_DET_PARAM');
12:
13: --------------------------------------------------------------------------
14: -- --

Line 11: g_salary_detail VARCHAR2(5):= pay_magtape_generic.get_parameter_value('SAL_DET_PARAM');

7: g_gre_org_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM');
8: g_assess_year VARCHAR2(15) := pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM');
9: g_quarter VARCHAR2(15) := pay_magtape_generic.get_parameter_value('QUARTER_PARAM');
10: g_action_id VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REF_PARAM');
11: g_salary_detail VARCHAR2(5):= pay_magtape_generic.get_parameter_value('SAL_DET_PARAM');
12:
13: --------------------------------------------------------------------------
14: -- --
15: -- Name : GET_FILE_SEQ_NO --

Line 262: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

258: SELECT DISTINCT 'TOT_CHALLAN_REC=P'
259: , pay_in_24qc_er_returns.challan_rec_count_24qc
260: (g_gre_org_id
261: ,(g_assess_year||g_quarter)
262: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
263: , hll.lookup_code)
264: , 'TAN_OF_DED=P'
265: , pai.action_information2
266: , 'SAL_DET=P'

Line 326: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

322: , 'GROSS_TDS_CHALLAN=P'
323: , pay_in_24qc_er_returns.gross_tot_tds_challan_24q
324: (g_gre_org_id
325: , (g_assess_year||g_quarter)
326: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
327: , hll.lookup_code)
328: , 'COUNT_SALARY=P'
329: , pay_in_24qc_er_returns.salary_rec_count(g_gre_org_id
330: ,g_assess_year||g_quarter

Line 332: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))

328: , 'COUNT_SALARY=P'
329: , pay_in_24qc_er_returns.salary_rec_count(g_gre_org_id
330: ,g_assess_year||g_quarter
331: , hll.lookup_code
332: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
333: , 'GROSS_TOTAL_INCOME=P'
334: , pay_in_24qc_er_returns.total_gross_tot_income(g_gre_org_id
335: , g_assess_year||g_quarter
336: , hll.lookup_code

Line 337: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))

333: , 'GROSS_TOTAL_INCOME=P'
334: , pay_in_24qc_er_returns.total_gross_tot_income(g_gre_org_id
335: , g_assess_year||g_quarter
336: , hll.lookup_code
337: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
338: FROM pay_action_information pai
339: ,hr_leg_lookups hll
340: WHERE pai.action_information_category = 'IN_24QC_ORG'
341: AND pai.action_context_type = 'PA'

Line 344: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

340: WHERE pai.action_information_category = 'IN_24QC_ORG'
341: AND pai.action_context_type = 'PA'
342: AND pai.action_information1 = g_gre_org_id
343: AND pai.action_information3 = g_assess_year||g_quarter
344: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
345: and hll.lookup_type = 'IN_FORM_24Q_CORRECTION_TYPES'
346: and INSTR(pai.action_information29,hll.lookup_code) <> 0;
347:
348:

Line 354: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

350: /* CHALLAN DETAIL RECORD */
351: CURSOR c_f24qc_challan_det_rec IS
352: SELECT DISTINCT 'TOT_DEDUCTEE_REC=P'
353: , pay_in_24qc_er_returns.deductee_rec_count_24q(g_gre_org_id
354: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
355: ,pai.action_information1)
356: , 'NIL_CHALLAN_IND=P'
357: , pay_in_24qc_er_returns.get_prev_nil_challan_ind(g_gre_org_id
358: , (g_assess_year||g_quarter)

Line 359: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))

355: ,pai.action_information1)
356: , 'NIL_CHALLAN_IND=P'
357: , pay_in_24qc_er_returns.get_prev_nil_challan_ind(g_gre_org_id
358: , (g_assess_year||g_quarter)
359: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
360: , 'QUARTER_LAST_DATE=P'
361: , DECODE(g_quarter,'Q1','3006','Q2','3009','Q3','3112','Q4','3103')
362: ||DECODE(g_quarter,'Q4',
363: SUBSTR(g_assess_year,1,4)

Line 391: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))

387: , 'LAST_TOTAL_AMOUNT_DEPO=P'
388: , NVL(pai.action_information19,'0.00')
389: , 'TAX_VALUES=P'
390: , pay_in_24qc_er_returns.get_24qc_tax_values(pai.action_information1,g_gre_org_id
391: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
392: , 'CHQ_DD_NUM=P'
393: , SUBSTR(pai.action_information11,1,15)||'^'
394: , 'BOOK_ENTRY=P'
395: , pai.action_information16

Line 405: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

401: WHERE action_information_category = 'IN_24QC_CHALLAN'
402: AND action_context_type = 'PA'
403: AND action_information3 = g_gre_org_id
404: AND action_information2 = g_assess_year||g_quarter
405: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
406: AND pai.action_information29 like '%'|| pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')||'%'
407: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
408: ORDER BY 40;
409:

Line 406: AND pai.action_information29 like '%'|| pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')||'%'

402: AND action_context_type = 'PA'
403: AND action_information3 = g_gre_org_id
404: AND action_information2 = g_assess_year||g_quarter
405: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
406: AND pai.action_information29 like '%'|| pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')||'%'
407: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
408: ORDER BY 40;
409:
410:

Line 453: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')

449: FROM pay_action_information pai
450: WHERE action_information_category ='IN_24QC_DEDUCTEE'
451: AND action_context_type = 'AAP'
452: AND action_information3 = g_gre_org_id
453: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
454: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'
455: AND INSTR(pai.action_information19, 'C5') <> 0)
456: OR
457: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'

Line 454: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'

450: WHERE action_information_category ='IN_24QC_DEDUCTEE'
451: AND action_context_type = 'AAP'
452: AND action_information3 = g_gre_org_id
453: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
454: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'
455: AND INSTR(pai.action_information19, 'C5') <> 0)
456: OR
457: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'
458: )

Line 457: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'

453: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
454: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'
455: AND INSTR(pai.action_information19, 'C5') <> 0)
456: OR
457: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'
458: )
459: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'
460: and(( INSTR(pai.action_information19, 'C3') <> 0) or action_information19 is null)
461: OR

Line 459: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'

455: AND INSTR(pai.action_information19, 'C5') <> 0)
456: OR
457: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'
458: )
459: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'
460: and(( INSTR(pai.action_information19, 'C3') <> 0) or action_information19 is null)
461: OR
462: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
463: ))

Line 462: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'

458: )
459: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'
460: and(( INSTR(pai.action_information19, 'C3') <> 0) or action_information19 is null)
461: OR
462: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
463: ))
464: AND EXISTS (SELECT 1
465: FROM pay_assignment_actions paa
466: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

Line 466: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

462: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
463: ))
464: AND EXISTS (SELECT 1
465: FROM pay_assignment_actions paa
466: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
467: AND paa.assignment_action_id = pai.action_context_id)
468: ORDER BY pai.action_information12, TO_NUMBER(action_information25) ASC;
469:
470:

Line 548: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')

544: WHERE action_information_category = 'IN_24QC_PERSON'
545: AND action_context_type = 'AAP'
546: AND action_information2 = g_assess_year||g_quarter
547: AND action_information3 = g_gre_org_id
548: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
549: AND action_context_id IN (SELECT MAX(pai.action_context_id)
550: FROM pay_action_information pai
551: ,pay_assignment_actions paa
552: ,per_assignments_f asg

Line 553: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

549: AND action_context_id IN (SELECT MAX(pai.action_context_id)
550: FROM pay_action_information pai
551: ,pay_assignment_actions paa
552: ,per_assignments_f asg
553: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
554: AND pai.action_context_id = paa.assignment_action_id
555: AND pai.action_information_category = 'IN_24QC_PERSON'
556: AND pai.action_context_type = 'AAP'
557: AND pai.action_information1 = asg.person_id

Line 562: AND pai.action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')

558: AND pai.action_information2 = g_assess_year||g_quarter
559: AND pai.action_information3 = g_gre_org_id
560: AND pai.assignment_id = asg.assignment_id
561: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
562: AND pai.action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
563: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9
564: )
565: ORDER BY fnd_number.canonical_to_number(action_information1),assignment_id,fnd_number.canonical_to_number(action_information12) ASC;
566:

Line 580: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')

576: ,pay_in_24q_er_returns.get_format_value(action_information2)
577: FROM pay_action_information
578: WHERE action_information_category = 'IN_24QC_VIA'
579: AND action_context_type = 'AAP'
580: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
581: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')
582: AND action_information1 IS NOT NULL
583: ORDER BY LENGTH(action_information1),source_id;
584:

Line 581: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')

577: FROM pay_action_information
578: WHERE action_information_category = 'IN_24QC_VIA'
579: AND action_context_type = 'AAP'
580: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
581: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')
582: AND action_information1 IS NOT NULL
583: ORDER BY LENGTH(action_information1),source_id;
584:
585: