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_AU_PAYMENT_SUMMARY dependencies on HR_ORGANIZATION_UNITS

Line 2827: (p_business_group_id in hr_organization_units.business_group_id%type,

2823: ----------------------------------------------------------------------+
2824: -- procedure to archive terminated employees details
2825: ----------------------------------------------------------------------+
2826: Procedure archive_etp_details
2827: (p_business_group_id in hr_organization_units.business_group_id%type,
2828: p_registered_employer in hr_organization_units.organization_id%type,
2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 2828: p_registered_employer in hr_organization_units.organization_id%type,

2824: -- procedure to archive terminated employees details
2825: ----------------------------------------------------------------------+
2826: Procedure archive_etp_details
2827: (p_business_group_id in hr_organization_units.business_group_id%type,
2828: p_registered_employer in hr_organization_units.organization_id%type,
2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,

Line 2862: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,

2858:
2859: -----------------------------------------------------------------------------------------------+
2860: -- cursor to fetch terminated employees details
2861: -----------------------------------------------------------------------------------------------+
2862: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
2863: c_registered_employer in hr_organization_units.organization_id%type,
2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2865: c_assignment_id in pay_assignment_actions.assignment_id%type,
2866: c_year_start in pay_payroll_actions.effective_date%type,

Line 2863: c_registered_employer in hr_organization_units.organization_id%type,

2859: -----------------------------------------------------------------------------------------------+
2860: -- cursor to fetch terminated employees details
2861: -----------------------------------------------------------------------------------------------+
2862: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
2863: c_registered_employer in hr_organization_units.organization_id%type,
2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2865: c_assignment_id in pay_assignment_actions.assignment_id%type,
2866: c_year_start in pay_payroll_actions.effective_date%type,
2867: c_year_end in pay_payroll_Actions.effective_date%type)

Line 2890: hr_organization_units hou,

2886: ,nvl(to_char(pps.actual_termination_date,'DDMMYYYY'),'31124712') employee_termination_date
2887: ,decode(pps.pds_information1, 'AU_D','Y', 'N') death_benefit/*bug#1955993*/
2888: ,pad.date_from date_from/*Bug 2977533 */
2889: from hr_organization_information hoi,
2890: hr_organization_units hou,
2891: hr_soft_coding_keyflex hsc,
2892: pay_element_types_f pet,
2893: pay_input_values_f piv,
2894: pay_element_links_f pel,

Line 3512: (p_business_group_id in hr_organization_units.business_group_id%type,

3508: -- this procedure archives all the data related to employer.
3509: ---------------------------------------------------------------------------------------+
3510:
3511: Procedure archive_employer_details
3512: (p_business_group_id in hr_organization_units.business_group_id%type,
3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 3514: p_registered_employer in hr_organization_units.organization_id%type,

3510:
3511: Procedure archive_employer_details
3512: (p_business_group_id in hr_organization_units.business_group_id%type,
3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,
3518: p_year_start in pay_payroll_actions.effective_date%type,

Line 3568: ,hr_organization_units hou

3564: ,ftl.territory_short_name country
3565: from hr_organization_information hoi
3566: ,hr_locations hlc
3567: ,fnd_territories_tl ftl
3568: ,hr_organization_units hou
3569: ,per_all_people_f papcont
3570: ,per_all_people_f papsign
3571: where hou.business_group_id = p_business_group_id
3572: and hou.organization_id = p_registered_employer

Line 3737: (p_business_group_id in hr_organization_units.business_group_id%type,

3733: -- this procedure archives all the data related to employee.
3734: ---------------------------------------------------------------------------------------+
3735:
3736: Procedure archive_employee_details
3737: (p_business_group_id in hr_organization_units.business_group_id%type,
3738: p_registered_employer in hr_organization_units.organization_id%type,
3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 3738: p_registered_employer in hr_organization_units.organization_id%type,

3734: ---------------------------------------------------------------------------------------+
3735:
3736: Procedure archive_employee_details
3737: (p_business_group_id in hr_organization_units.business_group_id%type,
3738: p_registered_employer in hr_organization_units.organization_id%type,
3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,

Line 3865: hr_organization_units hou,

3861: ,pps.actual_termination_date
3862: ,to_char(paaf.effective_start_date,'DDMMYYYY')
3863: ,to_char(paa.effective_end_date,'DDMMYYYY') -- Bug 2610141
3864: from hr_organization_information hoi,
3865: hr_organization_units hou,
3866: hr_soft_coding_keyflex hsc,
3867: hr_locations hlc, /* Bug No : 2263587 */
3868: per_all_assignments_f paa,
3869: per_all_assignments_f paaf, /* Bug : 2610141 */

Line 4260: (p_business_group_id in hr_organization_units.business_group_id%type,

4256: -- procedure to archive supplier details
4257: -- calls create_extract_archive_Details
4258: ------------------------------------------------------------------------+
4259: Procedure archive_supplier_details
4260: (p_business_group_id in hr_organization_units.business_group_id%type,
4261: p_registered_employer in hr_organization_units.organization_id%type,
4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 4261: p_registered_employer in hr_organization_units.organization_id%type,

4257: -- calls create_extract_archive_Details
4258: ------------------------------------------------------------------------+
4259: Procedure archive_supplier_details
4260: (p_business_group_id in hr_organization_units.business_group_id%type,
4261: p_registered_employer in hr_organization_units.organization_id%type,
4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,
4265: p_year_start in pay_payroll_actions.effective_date%type,

Line 4304: ,hr_organization_units hou

4300: ,hrl.postal_code supplier_postcode
4301: ,ftl.territory_short_name supplier_country
4302: ,pap.email_address email_address
4303: from hr_organization_information hoi
4304: ,hr_organization_units hou
4305: ,hr_locations hrl
4306: ,fnd_territories_tl ftl
4307: ,per_all_people_f pap
4308: where hou.business_group_id = p_business_group_id

Line 4566: l_registered_employer hr_organization_units.organization_id%type;

4562: --
4563: l_procedure constant varchar2(80) := g_package || '.archive_code';
4564: l_assignment_id pay_assignment_actions.assignment_id%type;
4565: l_business_group_id pay_payroll_actions.business_group_id%type ;
4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
4569: l_year_start pay_payroll_Actions.effective_date%type;
4570: l_year_end pay_payroll_actions.effective_date%type;

Line 4567: l_current_le hr_organization_units.organization_id%type; --4363057

4563: l_procedure constant varchar2(80) := g_package || '.archive_code';
4564: l_assignment_id pay_assignment_actions.assignment_id%type;
4565: l_business_group_id pay_payroll_actions.business_group_id%type ;
4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
4569: l_year_start pay_payroll_Actions.effective_date%type;
4570: l_year_end pay_payroll_actions.effective_date%type;
4571: l_employee_type per_all_people_f.current_Employee_Flag%type;

Line 4744: ,c_legal_employer hr_organization_units.organization_id%type

4740: employee details. This cursor should also execute only when the employee is not active in the current financial year for the submitted legal employer.
4741: */
4742: cursor csr_check_eff_le
4743: (c_assignment_id per_assignments_f.assignment_id%type
4744: ,c_legal_employer hr_organization_units.organization_id%type
4745: ,c_year_start pay_payroll_actions.effective_date%type
4746: ,c_year_end pay_payroll_actions.effective_date%type
4747: ) is
4748: select paaf.assignment_id

Line 4763: ,c_legal_employer hr_organization_units.organization_id%type

4759: cursor csr_get_dates
4760: (c_assignment_id per_assignments_f.assignment_id%type
4761: ,c_year_start pay_payroll_actions.effective_date%type
4762: ,c_year_end pay_payroll_actions.effective_date%type
4763: ,c_legal_employer hr_organization_units.organization_id%type
4764: ) is
4765: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')
4766: from pay_assignment_actions paa,
4767: pay_payroll_actions ppa,