APPS.PAY_AU_RECON_SUMMARY dependencies on HR_ORGANIZATION_UNITS

Line 155: g_business_group_id hr_organization_units.organization_id%type;

151: /* Begin 8587013 - Package variables declared to hold the totals of RESC and Exempt Foreign Employment Income balances*/
152: g_total_resc number;
153: g_total_foreign_income number;
154: /* End 8587013 */
155: g_business_group_id hr_organization_units.organization_id%type;
156: x number;
157: g_total_workplace number; /*4015082 */
158: g_balance_type_tab g_bal_type_tab;
159: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */

Line 1166: p_business_group_id hr_organization_units.organization_id%type,

1162: end Total_Invalidity_Payments;
1163:
1164: --Bug#3749530 - Function modified to set globals parmaters
1165: function populate_bal_ids(p_le_level IN varchar2 DEFAULT NULL,
1166: p_business_group_id hr_organization_units.organization_id%type,
1167: p_lst_yr_term VARCHAR2 DEFAULT NULL ) return number
1168: is
1169:
1170: /* Bug#3004966 - Added two Balances 'Termination Deductions', 'Total_Tax_Deductions'*/

Line 2934: l_business_group_id hr_organization_units.organization_id%type;

2930:
2931: l_lst_yr_start date;
2932: l_lst_fbt_yr_start date;
2933: l_assignment_id varchar2(50);
2934: l_business_group_id hr_organization_units.organization_id%type;
2935: l_legal_employer varchar2(50);
2936: l_employee_type varchar2(2);
2937: l_payroll_id varchar2(50);
2938: l_fin_year_start date;

Line 2970: p_business_group_id hr_organization_units.organization_id%type,

2966: select pay_assignment_actions_s.nextval
2967: from dual;
2968:
2969: cursor c_asgids(p_assignment_id varchar2,
2970: p_business_group_id hr_organization_units.organization_id%type,
2971: p_legal_employer varchar2,
2972: p_employee_type varchar2,
2973: p_payroll_id varchar2,
2974: p_fin_year_start date,

Line 3057: p_business_group_id hr_organization_units.organization_id%type,

3053:
3054: /* Bug: 12400821 - Performance Improvement done */
3055: CURSOR c_range_asgids
3056: (p_assignment_id varchar2,
3057: p_business_group_id hr_organization_units.organization_id%type,
3058: p_legal_employer varchar2,
3059: p_employee_type varchar2,
3060: p_payroll_id varchar2,
3061: p_fin_year_start date,

Line 3134: p_business_group_id hr_organization_units.organization_id%type,

3130: );
3131:
3132:
3133: cursor c_asgid_only(p_assignment_id varchar2,
3134: p_business_group_id hr_organization_units.organization_id%type,
3135: p_legal_employer varchar2,
3136: p_employee_type varchar2,
3137: p_payroll_id varchar2,
3138: p_fin_year_start date,