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

Line 10: from pay_payroll_actions bppa,

6: g_debug boolean;
7:
8: c_range_cursor constant varchar2(3000) := -- 4660184
9: 'select distinct paa.person_id
10: from pay_payroll_actions bppa,
11: per_assignments_f paa
12: where bppa.payroll_action_id = :payroll_action_id
13: and paa.business_group_id = bppa.business_group_id
14: and paa.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(bppa.payroll_action_id, ''PAYROLL_ID'', null))

Line 130: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

126: Procedure archive_corp_details
127: (p_business_group_id in hr_organization_units.business_group_id%type,
128: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
129: p_assignment_id in pay_assignment_actions.assignment_id%type,
130: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
131: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
132: p_date_earned in date ) is
133:
134:

Line 235: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

231: Function archive_emp_details
232: (p_business_group_id in hr_organization_units.business_group_id%type,
233: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
234: p_assignment_id in pay_assignment_actions.assignment_id%type,
235: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
236: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
237: p_date_earned in date )
238: return boolean
239: is

Line 261: pay_payroll_actions ppa,

257: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
258: ,ft.territory_code country_code
259: from pay_run_results prr1,
260: pay_run_results prr2,
261: pay_payroll_actions ppa,
262: pay_assignment_actions paa,
263: pay_element_types_f pet1,
264: pay_element_types_f pet2,
265: pay_input_values_f piv1,

Line 332: pay_payroll_actions ppa,

328: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) ns_leaving_date
329: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) ns_prev_hire_date
330: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) ns_prev_leaving_date
331: from pay_run_results prr1,
332: pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_element_types_f pet1,
335: pay_input_values_f piv1,
336: pay_input_values_f piv2,

Line 471: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

467: Procedure archive_prev_emp_details
468: (p_business_group_id in hr_organization_units.business_group_id%type,
469: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
470: p_assignment_id in pay_assignment_actions.assignment_id%type,
471: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
472: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
473: p_date_earned in date ) is
474:
475: cursor c_prev_emp_details(v_element_name varchar2,v_piv_name varchar2)

Line 482: pay_payroll_actions ppa,

478: peev1.screen_entry_value
479: from pay_element_entries_f pee,
480: pay_element_links_f pel,
481: pay_element_types_f pet,
482: pay_payroll_actions ppa,
483: pay_assignment_actions paa,
484: pay_run_types_f prt,
485: pay_input_values_f piv1,
486: pay_element_entry_values_f peev1

Line 738: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

734: Procedure archive_xdbi
735: (p_business_group_id in hr_organization_units.business_group_id%type,
736: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
737: p_assignment_id in pay_assignment_actions.assignment_id%type,
738: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
739: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
740: p_date_earned in date ) is
741: begin
742:

Line 800: pay_payroll_actions ppa,

796: paa.assignment_action_id,
797: paa.source_action_id,
798: paa.tax_unit_id
799: from pay_run_types_f prt,
800: pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f pa,
803: pay_payroll_actions bppa
804: where bppa.payroll_action_id = p_payroll_action_id

Line 803: pay_payroll_actions bppa

799: from pay_run_types_f prt,
800: pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f pa,
803: pay_payroll_actions bppa
804: where bppa.payroll_action_id = p_payroll_action_id
805: and pa.business_group_id = bppa.business_group_id
806: and pa.person_id
807: between p_start_person_id and p_end_person_id

Line 824: from pay_payroll_actions appa,

820: and prt.run_type_name like 'SEP%'
821: and prt.run_type_name <> 'SEP_L'
822: and not exists(
823: select 'x'
824: from pay_payroll_actions appa,
825: pay_assignment_actions apaa,
826: pay_action_interlocks pai
827: where pai.locked_action_id = paa.assignment_action_id
828: and apaa.assignment_action_id = pai.locking_action_id

Line 835: from pay_payroll_actions ppa2,

831: and appa.report_type = bppa.report_type
832: and trunc(appa.effective_date,'YYYY') = trunc(bppa.effective_date,'YYYY')
833: union all -- 4660184
834: select 'x'
835: from pay_payroll_actions ppa2,
836: pay_run_types_f prt2,
837: pay_assignment_actions paa2
838: where paa2.assignment_id = paa.assignment_id
839: and prt2.run_type_id = paa2.run_type_id

Line 945: from pay_payroll_actions ppa,

941: paa.assignment_id,
942: paa.assignment_action_id,
943: ppa.date_earned,
944: paa.tax_unit_id
945: from pay_payroll_actions ppa,
946: pay_assignment_actions paa,
947: pay_action_interlocks pai,
948: pay_assignment_actions xpaa
949: where xpaa.assignment_action_id = p_assignment_action_id