APPS.PAY_FR_DADS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 9: g_param_issuing_estab_id hr_organization_information.organization_id%TYPE;

5: --
6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_dads_pkg.';
7: --
8: g_cache_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_param_issuing_estab_id hr_organization_information.organization_id%TYPE;
10: g_param_company_id hr_organization_information.organization_id%TYPE;
11: g_param_estab_id hr_organization_information.organization_id%TYPE;
12: g_param_business_group_id per_business_Groups.business_group_id%TYPE;
13: g_param_reference varchar2(50);

Line 10: g_param_company_id hr_organization_information.organization_id%TYPE;

6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_dads_pkg.';
7: --
8: g_cache_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_param_issuing_estab_id hr_organization_information.organization_id%TYPE;
10: g_param_company_id hr_organization_information.organization_id%TYPE;
11: g_param_estab_id hr_organization_information.organization_id%TYPE;
12: g_param_business_group_id per_business_Groups.business_group_id%TYPE;
13: g_param_reference varchar2(50);
14: g_param_start_date date;

Line 11: g_param_estab_id hr_organization_information.organization_id%TYPE;

7: --
8: g_cache_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_param_issuing_estab_id hr_organization_information.organization_id%TYPE;
10: g_param_company_id hr_organization_information.organization_id%TYPE;
11: g_param_estab_id hr_organization_information.organization_id%TYPE;
12: g_param_business_group_id per_business_Groups.business_group_id%TYPE;
13: g_param_reference varchar2(50);
14: g_param_start_date date;
15: g_param_effective_date date;

Line 81: ,hr_organization_information org_est

77: ,paa_run.assignment_action_id)) mst_action_id
78: from pay_assignment_Actions paa_run
79: ,pay_payroll_actions ppa_run
80: ,per_all_assignments_f asg_run
81: ,hr_organization_information org_est
82: ,hr_organization_information org_coy
83: where ppa_run.business_group_id = asg_run.business_group_id
84: and asg_run.business_group_id = g_param_business_group_id
85: and ppa_run.payroll_action_id = paa_run.payroll_Action_id

Line 82: ,hr_organization_information org_coy

78: from pay_assignment_Actions paa_run
79: ,pay_payroll_actions ppa_run
80: ,per_all_assignments_f asg_run
81: ,hr_organization_information org_est
82: ,hr_organization_information org_coy
83: where ppa_run.business_group_id = asg_run.business_group_id
84: and asg_run.business_group_id = g_param_business_group_id
85: and ppa_run.payroll_action_id = paa_run.payroll_Action_id
86: and ppa_run.action_type in ('R','Q')

Line 203: from hr_organization_information hoi,

199: -- Cursor for getting companies
200: -- for the selected issuing establishment
201: cursor get_compid_cur is
202: select distinct hoi.organization_id organization_id
203: from hr_organization_information hoi,
204: hr_organization_information hoi_issue
205: where hoi.org_information_context = 'CLASS'
206: and hoi.org_information1 = 'FR_SOCIETE'
207: and hoi_issue.organization_id = hoi.organization_id

Line 204: hr_organization_information hoi_issue

200: -- for the selected issuing establishment
201: cursor get_compid_cur is
202: select distinct hoi.organization_id organization_id
203: from hr_organization_information hoi,
204: hr_organization_information hoi_issue
205: where hoi.org_information_context = 'CLASS'
206: and hoi.org_information1 = 'FR_SOCIETE'
207: and hoi_issue.organization_id = hoi.organization_id
208: and hoi_issue.org_information_context = 'FR_COMP_INFO'

Line 331: from hr_organization_information hoi,

327: -- Cursor for getting companies
328: -- for the selected issuing establishment
329: cursor S20 is
330: select distinct hoi.organization_id
331: from hr_organization_information hoi,
332: hr_organization_information hoi_issue
333: where hoi.org_information_context ||'' = 'CLASS'
334: and hoi.org_information1 = 'FR_SOCIETE'
335: and hoi_issue.organization_id =hoi.organization_id

Line 332: hr_organization_information hoi_issue

328: -- for the selected issuing establishment
329: cursor S20 is
330: select distinct hoi.organization_id
331: from hr_organization_information hoi,
332: hr_organization_information hoi_issue
333: where hoi.org_information_context ||'' = 'CLASS'
334: and hoi.org_information1 = 'FR_SOCIETE'
335: and hoi_issue.organization_id =hoi.organization_id
336: and hoi_issue.org_information_context = 'FR_COMP_INFO'