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 125: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

121: Procedure archive_corp_details
122: (p_business_group_id in hr_organization_units.business_group_id%type,
123: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
124: p_assignment_id in pay_assignment_actions.assignment_id%type,
125: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
126: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
127: p_date_earned in date ) is
128:
129:

Line 230: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

226: Function archive_emp_details
227: (p_business_group_id in hr_organization_units.business_group_id%type,
228: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
229: p_assignment_id in pay_assignment_actions.assignment_id%type,
230: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
231: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
232: p_date_earned in date )
233: return boolean
234: is

Line 256: pay_payroll_actions ppa,

252: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
253: ,decode(substr(pap.national_identifier,8,1),1,NULL,2,NULL,3,NULL,4,NULL,pap.country_of_birth) country_code
254: from pay_run_results prr1,
255: pay_run_results prr2,
256: pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_element_types_f pet1,
259: pay_element_types_f pet2,
260: pay_input_values_f piv1,

Line 323: pay_payroll_actions ppa,

319: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) ns_leaving_date
320: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) ns_prev_hire_date
321: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) ns_prev_leaving_date
322: from pay_run_results prr1,
323: pay_payroll_actions ppa,
324: pay_assignment_actions paa,
325: pay_element_types_f pet1,
326: pay_input_values_f piv1,
327: pay_input_values_f piv2,

Line 462: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

458: Procedure archive_prev_emp_details
459: (p_business_group_id in hr_organization_units.business_group_id%type,
460: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
461: p_assignment_id in pay_assignment_actions.assignment_id%type,
462: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
463: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
464: p_date_earned in date ) is
465:
466: cursor c_prev_emp_details(v_piv_name varchar2)

Line 473: pay_payroll_actions ppa,

469: peev1.screen_entry_value
470: from pay_element_entries_f pee,
471: pay_element_links_f pel,
472: pay_element_types_f pet,
473: pay_payroll_actions ppa,
474: pay_assignment_actions paa,
475: pay_run_types_f prt,
476: pay_input_values_f piv1,
477: pay_element_entry_values_f peev1

Line 635: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

631: Procedure archive_xdbi
632: (p_business_group_id in hr_organization_units.business_group_id%type,
633: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
634: p_assignment_id in pay_assignment_actions.assignment_id%type,
635: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
636: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
637: p_date_earned in date ) is
638: begin
639:

Line 697: pay_payroll_actions ppa,

693: paa.assignment_action_id,
694: paa.source_action_id,
695: paa.tax_unit_id
696: from pay_run_types_f prt,
697: pay_payroll_actions ppa,
698: pay_assignment_actions paa,
699: per_assignments_f pa,
700: pay_payroll_actions bppa
701: where bppa.payroll_action_id = p_payroll_action_id

Line 700: pay_payroll_actions bppa

696: from pay_run_types_f prt,
697: pay_payroll_actions ppa,
698: pay_assignment_actions paa,
699: per_assignments_f pa,
700: pay_payroll_actions bppa
701: where bppa.payroll_action_id = p_payroll_action_id
702: and pa.business_group_id = bppa.business_group_id
703: and pa.person_id
704: between p_start_person_id and p_end_person_id

Line 721: from pay_payroll_actions appa,

717: and prt.run_type_name like 'SEP%'
718: and prt.run_type_name <> 'SEP_L'
719: and not exists(
720: select 'x'
721: from pay_payroll_actions appa,
722: pay_assignment_actions apaa,
723: pay_action_interlocks pai
724: where pai.locked_action_id = paa.assignment_action_id
725: and apaa.assignment_action_id = pai.locking_action_id

Line 732: from pay_payroll_actions ppa2,

728: and appa.report_type = bppa.report_type
729: and trunc(appa.effective_date,'YYYY') = trunc(bppa.effective_date,'YYYY')
730: union all -- 4660184
731: select 'x'
732: from pay_payroll_actions ppa2,
733: pay_run_types_f prt2,
734: pay_assignment_actions paa2
735: where paa2.assignment_id = paa.assignment_id
736: and prt2.run_type_id = paa2.run_type_id

Line 842: from pay_payroll_actions ppa,

838: paa.assignment_id,
839: paa.assignment_action_id,
840: ppa.date_earned,
841: paa.tax_unit_id
842: from pay_payroll_actions ppa,
843: pay_assignment_actions paa,
844: pay_action_interlocks pai,
845: pay_assignment_actions xpaa
846: where xpaa.assignment_action_id = p_assignment_action_id