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 153: FROM pay_payroll_actions ppa

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

Line 279: pay_payroll_actions ppa,

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

Line 281: pay_payroll_actions ppa1,

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

Line 359: pay_payroll_actions ppa, -- YREND PPA

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

Line 361: pay_payroll_actions ppa1,

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

Line 688: pay_payroll_actions ppa,

684: ppa.legislative_parameters),
685: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
686: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
687: FROM pay_assignment_actions paa,
688: pay_payroll_actions ppa,
689: pay_action_interlocks pai,
690: pay_assignment_actions paa1,
691: pay_payroll_actions ppa1
692: where ppa.payroll_action_id = paa.payroll_action_id

Line 691: pay_payroll_actions ppa1

687: FROM pay_assignment_actions paa,
688: pay_payroll_actions ppa,
689: pay_action_interlocks pai,
690: pay_assignment_actions paa1,
691: pay_payroll_actions ppa1
692: where ppa.payroll_action_id = paa.payroll_action_id
693: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
694: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
695: and pai.locking_action_id = paa.assignment_action_id

Line 843: token_val pay_payroll_actions.legislative_parameters%type;

839: parameter_list varchar2) return varchar2
840: is
841: start_ptr number;
842: end_ptr number;
843: token_val pay_payroll_actions.legislative_parameters%type;
844: par_value pay_payroll_actions.legislative_parameters%type;
845: begin
846: --
847: token_val := name||'=';

Line 844: par_value pay_payroll_actions.legislative_parameters%type;

840: is
841: start_ptr number;
842: end_ptr number;
843: token_val pay_payroll_actions.legislative_parameters%type;
844: par_value pay_payroll_actions.legislative_parameters%type;
845: begin
846: --
847: token_val := name||'=';
848: --