DBA Data[Home] [Help]

APPS.PAY_US_MAGTAPE_REPORTING dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 1484: from pay_report_format_mappings_f RM

1480: --
1481: -- SQWLD - cursor for tape format expects *no* 'D' at end of format name
1482: cursor csr_tape_format is
1483: select RM.report_format
1484: from pay_report_format_mappings_f RM
1485: where RM.report_type = p_report_type
1486: and RM.report_qualifier = p_state
1487: and RM.report_format not like '%D'
1488: and p_period_end between RM.effective_start_date

Line 1494: from pay_report_format_mappings_f RM

1490: --
1491: -- SQWLD - cursor for disk format expects 'D' at end of format name
1492: cursor csr_disk_format is
1493: select RM.report_format
1494: from pay_report_format_mappings_f RM
1495: where RM.report_type = p_report_type
1496: and RM.report_qualifier = p_state
1497: and RM.report_format like '%D'
1498: and p_period_end between RM.effective_start_date