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_MMREF_LOCAL_XML dependencies on PAY_PAYROLL_ACTIONS

Line 154: FROM pay_payroll_actions ppa

150: p_business_group_id,
151: p_state_abbrev,
152: p_report_type,
153: p_locality_code
154: FROM pay_payroll_actions ppa
155: WHERE ppa.payroll_action_id = p_pactid;
156: --
157: select state_code into l_state_code
158: from pay_us_states pus

Line 280: pay_payroll_actions ppa,

276: FROM ff_archive_item_contexts faic,
277: ff_archive_items fai,
278: ff_database_items fdi,
279: pay_assignment_actions paa,
280: pay_payroll_actions ppa,
281: per_all_assignments_f paf,
282: pay_payroll_actions ppa1,
283: pay_us_states pus
284: WHERE ppa1.payroll_action_id = :payroll_action_id

Line 282: pay_payroll_actions ppa1,

278: ff_database_items fdi,
279: pay_assignment_actions paa,
280: pay_payroll_actions ppa,
281: per_all_assignments_f paf,
282: pay_payroll_actions ppa1,
283: pay_us_states pus
284: WHERE ppa1.payroll_action_id = :payroll_action_id
285: AND ppa.business_group_id+0 = ppa1.business_group_id
286: AND ppa1.effective_date = ppa.effective_date

Line 360: pay_payroll_actions ppa, -- YREND PPA

356: paa.assignment_action_id,
357: sum(fai1.value)
358: FROM
359: pay_assignment_actions paa, -- YREND PAA
360: pay_payroll_actions ppa, -- YREND PPA
361: per_all_assignments_f paf,
362: pay_payroll_actions ppa1,
363: ff_contexts fc1 , --for city context
364: ff_archive_items fai1, -- city

Line 362: pay_payroll_actions ppa1,

358: FROM
359: pay_assignment_actions paa, -- YREND PAA
360: pay_payroll_actions ppa, -- YREND PPA
361: per_all_assignments_f paf,
362: pay_payroll_actions ppa1,
363: ff_contexts fc1 , --for city context
364: ff_archive_items fai1, -- city
365: ff_archive_item_contexts faic1, -- city_context
366: ff_database_items fdi1 --database_items for City_withheld

Line 424: pay_payroll_actions ppa, -- YREND PPA

420: paa.assignment_action_id,
421: sum(fai1.value)
422: FROM
423: pay_assignment_actions paa, -- YREND PAA
424: pay_payroll_actions ppa, -- YREND PPA
425: per_all_assignments_f paf,
426: pay_payroll_actions ppa1,
427: ff_contexts fc1 , --for city context
428: ff_archive_items fai1, -- city

Line 426: pay_payroll_actions ppa1,

422: FROM
423: pay_assignment_actions paa, -- YREND PAA
424: pay_payroll_actions ppa, -- YREND PPA
425: per_all_assignments_f paf,
426: pay_payroll_actions ppa1,
427: ff_contexts fc1 , --for city context
428: ff_archive_items fai1, -- city
429: ff_archive_item_contexts faic1, -- city_context
430: ff_database_items fdi1

Line 751: pay_payroll_actions ppa,

747: ppa.legislative_parameters),
748: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
750: FROM pay_assignment_actions paa,
751: pay_payroll_actions ppa,
752: pay_action_interlocks pai,
753: pay_assignment_actions paa1,
754: pay_payroll_actions ppa1
755: where ppa.payroll_action_id = paa.payroll_action_id

Line 754: pay_payroll_actions ppa1

750: FROM pay_assignment_actions paa,
751: pay_payroll_actions ppa,
752: pay_action_interlocks pai,
753: pay_assignment_actions paa1,
754: pay_payroll_actions ppa1
755: where ppa.payroll_action_id = paa.payroll_action_id
756: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
757: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
758: and pai.locking_action_id = paa.assignment_action_id

Line 906: token_val pay_payroll_actions.legislative_parameters%type;

902: parameter_list varchar2) return varchar2
903: is
904: start_ptr number;
905: end_ptr number;
906: token_val pay_payroll_actions.legislative_parameters%type;
907: par_value pay_payroll_actions.legislative_parameters%type;
908: begin
909: --
910: token_val := name||'=';

Line 907: par_value pay_payroll_actions.legislative_parameters%type;

903: is
904: start_ptr number;
905: end_ptr number;
906: token_val pay_payroll_actions.legislative_parameters%type;
907: par_value pay_payroll_actions.legislative_parameters%type;
908: begin
909: --
910: token_val := name||'=';
911: --