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.

[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on HR_ORGANIZATION_UNITS

Line 756: l_registered_employer hr_organization_units.organization_id%type;

752: and pbt.business_group_id = g_business_group_id;
753:
754: cnt number := 1;
755: idx number := 1;
756: l_registered_employer hr_organization_units.organization_id%type;
757: l_fw_asg_f_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
758: l_fw_asg_j_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
759: l_fw_exist varchar2(1);
760: raise_no_status_type exception;

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

5101: ----------------------------------------------------------------------+
5102: -- procedure to archive terminated employees details
5103: ----------------------------------------------------------------------+
5104: Procedure archive_etp_details
5105: (p_business_group_id in hr_organization_units.business_group_id%type,
5106: p_registered_employer in hr_organization_units.organization_id%type,
5107: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5108: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
5109: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 5106: p_registered_employer in hr_organization_units.organization_id%type,

5102: -- procedure to archive terminated employees details
5103: ----------------------------------------------------------------------+
5104: Procedure archive_etp_details
5105: (p_business_group_id in hr_organization_units.business_group_id%type,
5106: p_registered_employer in hr_organization_units.organization_id%type,
5107: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5108: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
5109: p_assignment_id in pay_assignment_actions.assignment_id%type,
5110: p_year_start in pay_payroll_actions.effective_date%type,

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

5137: -----------------------------------------------------------------------------------------------+
5138: -- cursor to fetch terminated employees details
5139: -----------------------------------------------------------------------------------------------+
5140: /*Bug 8315198 - Modified cursor to fetch the Tax file number entered in termination form for employees recieving Death Benefit ETP */
5141: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
5142: c_registered_employer in hr_organization_units.organization_id%type,
5143: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5144: c_assignment_id in pay_assignment_actions.assignment_id%type,
5145: c_year_start in pay_payroll_actions.effective_date%type,

Line 5142: c_registered_employer in hr_organization_units.organization_id%type,

5138: -- cursor to fetch terminated employees details
5139: -----------------------------------------------------------------------------------------------+
5140: /*Bug 8315198 - Modified cursor to fetch the Tax file number entered in termination form for employees recieving Death Benefit ETP */
5141: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
5142: c_registered_employer in hr_organization_units.organization_id%type,
5143: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5144: c_assignment_id in pay_assignment_actions.assignment_id%type,
5145: c_year_start in pay_payroll_actions.effective_date%type,
5146: c_year_end in pay_payroll_Actions.effective_date%type)

Line 5170: hr_organization_units hou,

5166: ,decode(pps.pds_information1, 'AU_D','Y', 'N') death_benefit/*bug#1955993*/
5167: ,pad.date_from date_from/*Bug 2977533 */
5168: ,decode(pps.pds_information1, 'AU_D',nvl(pps.pds_information11,'000 000 000'),pev.screen_entry_value) etp_death_benefit_tfn /*Bug#8315198*/
5169: from hr_organization_information hoi,
5170: hr_organization_units hou,
5171: hr_soft_coding_keyflex hsc,
5172: pay_element_types_f pet,
5173: pay_input_values_f piv,
5174: pay_element_links_f pel,

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

6951: -- this procedure archives all the data related to employer.
6952: ---------------------------------------------------------------------------------------+
6953:
6954: Procedure archive_employer_details
6955: (p_business_group_id in hr_organization_units.business_group_id%type,
6956: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
6957: p_registered_employer in hr_organization_units.organization_id%type,
6958: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 6957: p_registered_employer in hr_organization_units.organization_id%type,

6953:
6954: Procedure archive_employer_details
6955: (p_business_group_id in hr_organization_units.business_group_id%type,
6956: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
6957: p_registered_employer in hr_organization_units.organization_id%type,
6958: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
6960: p_assignment_id in pay_assignment_actions.assignment_id%type,
6961: p_year_start in pay_payroll_actions.effective_date%type,

Line 7011: ,hr_organization_units hou

7007: ,ftl.territory_short_name country
7008: from hr_organization_information hoi
7009: ,hr_locations hlc
7010: ,fnd_territories_tl ftl
7011: ,hr_organization_units hou
7012: ,per_all_people_f papcont
7013: ,per_all_people_f papsign
7014: where hou.business_group_id = p_business_group_id
7015: and hou.organization_id = p_registered_employer

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

7176: -- this procedure archives all the data related to employee.
7177: ---------------------------------------------------------------------------------------+
7178:
7179: Procedure archive_employee_details
7180: (p_business_group_id in hr_organization_units.business_group_id%type,
7181: p_registered_employer in hr_organization_units.organization_id%type,
7182: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7183: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
7184: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 7181: p_registered_employer in hr_organization_units.organization_id%type,

7177: ---------------------------------------------------------------------------------------+
7178:
7179: Procedure archive_employee_details
7180: (p_business_group_id in hr_organization_units.business_group_id%type,
7181: p_registered_employer in hr_organization_units.organization_id%type,
7182: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7183: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
7184: p_assignment_id in pay_assignment_actions.assignment_id%type,
7185: p_year_start in pay_payroll_actions.effective_date%type,

Line 7310: hr_organization_units hou,

7306: ,to_char(paaf.effective_start_date,'DDMMYYYY')
7307: ,to_char(paa.effective_end_date,'DDMMYYYY') -- Bug 2610141
7308: ,pps.pds_information1 termination_type --Bug 8315198
7309: from hr_organization_information hoi,
7310: hr_organization_units hou,
7311: hr_soft_coding_keyflex hsc,
7312: hr_locations hlc, /* Bug No : 2263587 */
7313: per_all_assignments_f paa,
7314: per_all_assignments_f paaf, /* Bug : 2610141 */

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

7718: -- procedure to archive supplier details
7719: -- calls create_extract_archive_Details
7720: ------------------------------------------------------------------------+
7721: Procedure archive_supplier_details
7722: (p_business_group_id in hr_organization_units.business_group_id%type,
7723: p_registered_employer in hr_organization_units.organization_id%type,
7724: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7725: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
7726: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 7723: p_registered_employer in hr_organization_units.organization_id%type,

7719: -- calls create_extract_archive_Details
7720: ------------------------------------------------------------------------+
7721: Procedure archive_supplier_details
7722: (p_business_group_id in hr_organization_units.business_group_id%type,
7723: p_registered_employer in hr_organization_units.organization_id%type,
7724: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7725: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
7726: p_assignment_id in pay_assignment_actions.assignment_id%type,
7727: p_year_start in pay_payroll_actions.effective_date%type,

Line 7766: ,hr_organization_units hou

7762: ,hrl.postal_code supplier_postcode
7763: ,ftl.territory_short_name supplier_country
7764: ,pap.email_address email_address
7765: from hr_organization_information hoi
7766: ,hr_organization_units hou
7767: ,hr_locations hrl
7768: ,fnd_territories_tl ftl
7769: ,per_all_people_f pap
7770: where hou.business_group_id = p_business_group_id

Line 8028: l_registered_employer hr_organization_units.organization_id%type;

8024: --
8025: l_procedure constant varchar2(80) := g_package || '.archive_code';
8026: l_assignment_id pay_assignment_actions.assignment_id%type;
8027: l_business_group_id pay_payroll_actions.business_group_id%type ;
8028: l_registered_employer hr_organization_units.organization_id%type;
8029: l_current_le hr_organization_units.organization_id%type; --4363057
8030: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
8031: l_year_start pay_payroll_Actions.effective_date%type;
8032: l_year_end pay_payroll_actions.effective_date%type;

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

8025: l_procedure constant varchar2(80) := g_package || '.archive_code';
8026: l_assignment_id pay_assignment_actions.assignment_id%type;
8027: l_business_group_id pay_payroll_actions.business_group_id%type ;
8028: l_registered_employer hr_organization_units.organization_id%type;
8029: l_current_le hr_organization_units.organization_id%type; --4363057
8030: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;
8031: l_year_start pay_payroll_Actions.effective_date%type;
8032: l_year_end pay_payroll_actions.effective_date%type;
8033: l_employee_type per_all_people_f.current_Employee_Flag%type;

Line 8215: ,c_legal_employer hr_organization_units.organization_id%type

8211: employee details. This cursor should also execute only when the employee is not active in the current financial year for the submitted legal employer.
8212: */
8213: cursor csr_check_eff_le
8214: (c_assignment_id per_assignments_f.assignment_id%type
8215: ,c_legal_employer hr_organization_units.organization_id%type
8216: ,c_year_start pay_payroll_actions.effective_date%type
8217: ,c_year_end pay_payroll_actions.effective_date%type
8218: ) is
8219: select paaf.assignment_id

Line 8234: ,c_legal_employer hr_organization_units.organization_id%type

8230: cursor csr_get_dates
8231: (c_assignment_id per_assignments_f.assignment_id%type
8232: ,c_year_start pay_payroll_actions.effective_date%type
8233: ,c_year_end pay_payroll_actions.effective_date%type
8234: ,c_legal_employer hr_organization_units.organization_id%type
8235: ) is
8236: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')
8237: from pay_assignment_actions paa,
8238: pay_payroll_actions ppa,