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: g_regular_file_date VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REGULAR_DATE_PARAM');

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: g_regular_file_date VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REGULAR_DATE_PARAM');
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: g_regular_file_date VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REGULAR_DATE_PARAM');
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: g_regular_file_date VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REGULAR_DATE_PARAM');
13:
14: --------------------------------------------------------------------------
15: -- --

Line 12: g_regular_file_date VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REGULAR_DATE_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: g_regular_file_date VARCHAR2(15) := pay_magtape_generic.get_parameter_value('REGULAR_DATE_PARAM');
13:
14: --------------------------------------------------------------------------
15: -- --
16: -- Name : GET_FILE_SEQ_NO --

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

263: SELECT DISTINCT 'TOT_CHALLAN_REC=P'
264: , pay_in_24qc_er_returns.challan_rec_count_24qc
265: (g_gre_org_id
266: ,(g_assess_year||g_quarter)
267: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
268: , hll.lookup_code)
269: , 'TAN_OF_DED=P'
270: , pai.action_information2
271: , 'SAL_DET=P'

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

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

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

333: , 'COUNT_SALARY=P'
334: , pay_in_24qc_er_returns.salary_rec_count(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: , 'GROSS_TOTAL_INCOME=P'
339: , pay_in_24qc_er_returns.total_gross_tot_income(g_gre_org_id
340: , g_assess_year||g_quarter
341: , hll.lookup_code

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

338: , 'GROSS_TOTAL_INCOME=P'
339: , pay_in_24qc_er_returns.total_gross_tot_income(g_gre_org_id
340: , g_assess_year||g_quarter
341: , hll.lookup_code
342: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
343: , 'STATE_NAME=P'
344: , hr_general.decode_lookup('IN_STATE_CODES',pai.action_information20)
345: , 'PAO_CODE=P'
346: , pai.action_information21

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

361: WHERE pai.action_information_category = 'IN_24QC_ORG'
362: AND pai.action_context_type = 'PA'
363: AND pai.action_information1 = g_gre_org_id
364: AND pai.action_information3 = g_assess_year||g_quarter
365: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
366: and hll.lookup_type = 'IN_FORM_24Q_CORRECTION_TYPES'
367: and INSTR(pai.action_information29,hll.lookup_code) <> 0;
368:
369:

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

371: /* CHALLAN DETAIL RECORD */
372: CURSOR c_f24qc_challan_det_rec IS
373: SELECT DISTINCT 'TOT_DEDUCTEE_REC=P'
374: , pay_in_24qc_er_returns.deductee_rec_count_24q(g_gre_org_id
375: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
376: ,pai.action_information1)
377: , 'NIL_CHALLAN_IND=P'
378: , pay_in_24qc_er_returns.get_prev_nil_challan_ind(g_gre_org_id
379: , (g_assess_year||g_quarter)

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

376: ,pai.action_information1)
377: , 'NIL_CHALLAN_IND=P'
378: , pay_in_24qc_er_returns.get_prev_nil_challan_ind(g_gre_org_id
379: , (g_assess_year||g_quarter)
380: , pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
381: , 'QUARTER_LAST_DATE=P'
382: , DECODE(g_quarter,'Q1','3006','Q2','3009','Q3','3112','Q4','3103')
383: ||DECODE(g_quarter,'Q4',
384: SUBSTR(g_assess_year,1,4)

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

408: , 'LAST_TOTAL_AMOUNT_DEPO=P'
409: , NVL(pai.action_information19,'0.00')
410: , 'TAX_VALUES=P'
411: , pay_in_24qc_er_returns.get_24qc_tax_values(pai.action_information1,g_gre_org_id
412: ,pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID'))
413: , 'CHQ_DD_NUM=P'
414: , SUBSTR(pai.action_information11,1,15)||'^'
415: , 'BOOK_ENTRY=P'
416: , pai.action_information16

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

424: WHERE action_information_category = 'IN_24QC_CHALLAN'
425: AND action_context_type = 'PA'
426: AND action_information3 = g_gre_org_id
427: AND action_information2 = g_assess_year||g_quarter
428: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
429: AND pai.action_information29 like '%'|| pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')||'%'
430: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
431: ORDER BY 40;
432:

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

425: AND action_context_type = 'PA'
426: AND action_information3 = g_gre_org_id
427: AND action_information2 = g_assess_year||g_quarter
428: AND pai.action_context_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
429: AND pai.action_information29 like '%'|| pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')||'%'
430: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
431: ORDER BY 40;
432:
433:

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

472: FROM pay_action_information pai
473: WHERE action_information_category ='IN_24QC_DEDUCTEE'
474: AND action_context_type = 'AAP'
475: AND action_information3 = g_gre_org_id
476: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
477: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'
478: AND INSTR(pai.action_information19, 'C5') <> 0)
479: OR
480: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'

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

473: WHERE action_information_category ='IN_24QC_DEDUCTEE'
474: AND action_context_type = 'AAP'
475: AND action_information3 = g_gre_org_id
476: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
477: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'
478: AND INSTR(pai.action_information19, 'C5') <> 0)
479: OR
480: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'
481: )

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

476: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
477: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C5'
478: AND INSTR(pai.action_information19, 'C5') <> 0)
479: OR
480: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'
481: )
482: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'
483: and(( INSTR(pai.action_information19, 'C3') <> 0) or action_information19 is null)
484: OR

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

478: AND INSTR(pai.action_information19, 'C5') <> 0)
479: OR
480: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C5'
481: )
482: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'
483: and(( INSTR(pai.action_information19, 'C3') <> 0) or action_information19 is null)
484: OR
485: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
486: ))

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

481: )
482: AND ((pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') = 'C3'
483: and(( INSTR(pai.action_information19, 'C3') <> 0) or action_information19 is null)
484: OR
485: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
486: ))
487: AND EXISTS (SELECT 1
488: FROM pay_assignment_actions paa
489: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')

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

485: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
486: ))
487: AND EXISTS (SELECT 1
488: FROM pay_assignment_actions paa
489: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
490: AND paa.assignment_action_id = pai.action_context_id)
491: ORDER BY pai.action_information12, TO_NUMBER(action_information25) ASC;
492:
493:

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

567: WHERE action_information_category = 'IN_24QC_PERSON'
568: AND action_context_type = 'AAP'
569: AND action_information2 = g_assess_year||g_quarter
570: AND action_information3 = g_gre_org_id
571: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
572: AND action_context_id IN (SELECT MAX(pai.action_context_id)
573: FROM pay_action_information pai
574: ,pay_assignment_actions paa
575: ,per_assignments_f asg

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

572: AND action_context_id IN (SELECT MAX(pai.action_context_id)
573: FROM pay_action_information pai
574: ,pay_assignment_actions paa
575: ,per_assignments_f asg
576: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
577: AND pai.action_context_id = paa.assignment_action_id
578: AND pai.action_information_category = 'IN_24QC_PERSON'
579: AND pai.action_context_type = 'AAP'
580: AND pai.action_information1 = asg.person_id

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

581: AND pai.action_information2 = g_assess_year||g_quarter
582: AND pai.action_information3 = g_gre_org_id
583: AND pai.assignment_id = asg.assignment_id
584: AND asg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
585: AND pai.action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
586: GROUP BY pai.assignment_id,pai.action_information1,pai.action_information9
587: )
588: ORDER BY fnd_number.canonical_to_number(action_information1),assignment_id,fnd_number.canonical_to_number(action_information12) ASC;
589:

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

599: ,pay_in_24q_er_returns.get_format_value(action_information2)
600: FROM pay_action_information
601: WHERE action_information_category = 'IN_24QC_VIA'
602: AND action_context_type = 'AAP'
603: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
604: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')
605: AND action_information1 IS NOT NULL
606: ORDER BY LENGTH(action_information1),source_id;
607:

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

600: FROM pay_action_information
601: WHERE action_information_category = 'IN_24QC_VIA'
602: AND action_context_type = 'AAP'
603: AND action_context_id = pay_magtape_generic.get_parameter_value('ACTION_CONTEXT_ID')
604: AND source_id =pay_magtape_generic.get_parameter_value('SOURCE_ID')
605: AND action_information1 IS NOT NULL
606: ORDER BY LENGTH(action_information1),source_id;
607:
608: