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_US_PSD_XML dependencies on PAY_US_GET_ITEM_DATA_PKG

Line 380: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

376:
377: SELECT ppa.start_date,
378: ppa.effective_date,
379: ppa.business_group_id,
380: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
381: 'TRANSFER_STATE'),
382: ppa.report_type,
383: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
384: 'TRANSFER_PERIOD_TYPE'),

Line 383: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

379: ppa.business_group_id,
380: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
381: 'TRANSFER_STATE'),
382: ppa.report_type,
383: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
384: 'TRANSFER_PERIOD_TYPE'),
385: decode (pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
386: 'TRANSFER_TAX_COLL_DIST_CODE'),'NULL',NULL, pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
387: 'TRANSFER_TAX_COLL_DIST_CODE'))

Line 385: decode (pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

381: 'TRANSFER_STATE'),
382: ppa.report_type,
383: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
384: 'TRANSFER_PERIOD_TYPE'),
385: decode (pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
386: 'TRANSFER_TAX_COLL_DIST_CODE'),'NULL',NULL, pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
387: 'TRANSFER_TAX_COLL_DIST_CODE'))
388: INTO p_year_start,
389: p_year_end,

Line 386: 'TRANSFER_TAX_COLL_DIST_CODE'),'NULL',NULL, pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

382: ppa.report_type,
383: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
384: 'TRANSFER_PERIOD_TYPE'),
385: decode (pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
386: 'TRANSFER_TAX_COLL_DIST_CODE'),'NULL',NULL, pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
387: 'TRANSFER_TAX_COLL_DIST_CODE'))
388: INTO p_year_start,
389: p_year_end,
390: p_business_group_id,

Line 403: /* SELECT fnd_date.canonical_to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

399: from pay_us_states pus
400: where pus.state_abbrev = p_state_abbrev;
401:
402: p_state_code := l_state_code;
403: /* SELECT fnd_date.canonical_to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
404: 'TRANSFER_DATE'))
405: INTO p_period_end
406: FROM pay_payroll_actions ppa
407: WHERE ppa.payroll_action_id = p_pactid;*/

Line 409: SELECT to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

405: INTO p_period_end
406: FROM pay_payroll_actions ppa
407: WHERE ppa.payroll_action_id = p_pactid;*/
408:
409: SELECT to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
410: 'TRANSFER_DATE'), 'DD-MON-YYYY')
411: INTO p_period_end
412: FROM pay_payroll_actions ppa
413: WHERE ppa.payroll_action_id = p_pactid;

Line 636: and pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,

632: AND AA.tax_unit_id = AA1.tax_unit_id
633: AND AA1.assignment_id = AA.assignment_id
634: AND AA1.payroll_action_id = PA1.payroll_action_id
635: AND PA1.report_type = 'YREND'
636: and pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,
637: 'TRANSFER_PERIOD_TYPE')= 'Yearly'
638: and to_char(pa1.effective_date, 'YYYY') = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,
639: 'TRANSFER_REPORTING_YEAR') */
640: SELECT pai.locked_action_id

Line 638: and to_char(pa1.effective_date, 'YYYY') = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,

634: AND AA1.payroll_action_id = PA1.payroll_action_id
635: AND PA1.report_type = 'YREND'
636: and pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,
637: 'TRANSFER_PERIOD_TYPE')= 'Yearly'
638: and to_char(pa1.effective_date, 'YYYY') = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,
639: 'TRANSFER_REPORTING_YEAR') */
640: SELECT pai.locked_action_id
641: FROM pay_action_interlocks pai
642: where pai.locking_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');

Line 862: AND ( ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,

858: SELECT 'Y'
859: FROM hr_organization_information
860: WHERE organization_id = hou.organization_id
861: AND org_information_context = '1099R Magnetic Report Rules')/*
862: AND ( ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
863: 'TRANSFER_PERIOD_TYPE') <> 'Yearly'
864: ) OR
865: ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
866: 'TRANSFER_PERIOD_TYPE') = 'Yearly'

Line 865: ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,

861: AND org_information_context = '1099R Magnetic Report Rules')/*
862: AND ( ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
863: 'TRANSFER_PERIOD_TYPE') <> 'Yearly'
864: ) OR
865: ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
866: 'TRANSFER_PERIOD_TYPE') = 'Yearly'
867: AND EXISTS ( select null
868: from pay_payroll_actions ppa
869: where to_number(substr(LEGISLATIVE_PARAMETERS,1,instr(LEGISLATIVE_PARAMETERS,' ',1)-1)) = puar.tax_unit_id

Line 871: and ppa.effective_date = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,

867: AND EXISTS ( select null
868: from pay_payroll_actions ppa
869: where to_number(substr(LEGISLATIVE_PARAMETERS,1,instr(LEGISLATIVE_PARAMETERS,' ',1)-1)) = puar.tax_unit_id
870: and ppa.report_type = 'YREND'
871: and ppa.effective_date = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
872: 'TRANSFER_DATE')
873: )
874: )
875: )*/;

Line 928: AND effective_date = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,

924: IS
925: SELECT payroll_action_id
926: FROM pay_payroll_actions
927: WHERE report_type = 'YREND'
928: AND effective_date = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
929: 'TRANSFER_DATE')
930: AND business_group_id+0 = p_business_group_id
931: AND SUBSTR(legislative_parameters,
932: INSTR(legislative_parameters, 'TRANSFER_GRE=') +

Line 945: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid

941: into l_effective_date
942: from pay_payroll_actions ppa
943: where ppa.payroll_action_id=p_pactid;
944:
945: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
946: ,'TRANSFER_PERIOD_TYPE') into l_period_type
947: from dual;
948:
949: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid

Line 949: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid

945: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
946: ,'TRANSFER_PERIOD_TYPE') into l_period_type
947: from dual;
948:
949: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid
950: ,'TRANSFER_TRANS_LEGAL_CO_ID') into l_transmitter
951: from dual;
952:
953: IF l_period_type <> 'Yearly' then

Line 2176: (select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

2172: select state_code
2173: into l_state_code
2174: from pay_us_states
2175: where state_abbrev =
2176: (select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
2177: 'TRANSFER_STATE')
2178: from pay_payroll_actions ppa
2179: where ppa.payroll_action_id = p_payroll_action_id);
2180: