APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on HR_ORGANIZATION_INFORMATION

Line 94: FROM hr_organization_information hoi,

90:
91: CURSOR cur_reporting_level(cp_payroll_action_id NUMBER)
92: IS
93: SELECT org_information1
94: FROM hr_organization_information hoi,
95: pay_payroll_actions ppa
96: where ppa.payroll_action_id = cp_payroll_action_id
97: and hoi.organization_id = ppa.business_group_id
98: and hoi.org_information_context = 'Payroll Archiver Level';

Line 101: lv_reporting_level hr_organization_information.org_information1%TYPE;

97: and hoi.organization_id = ppa.business_group_id
98: and hoi.org_information_context = 'Payroll Archiver Level';
99:
100: i NUMBER;
101: lv_reporting_level hr_organization_information.org_information1%TYPE;
102:
103: BEGIN
104:
105: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

Line 3594: FROM hr_organization_information

3590:
3591: CURSOR c_get_legislation_code (cp_business_group NUMBER)
3592: IS
3593: SELECT org_information9
3594: FROM hr_organization_information
3595: WHERE org_information_context = 'Business Group Information'
3596: AND organization_id = cp_business_group;
3597:
3598: /* Below cursor fetches the Assignment Actions corresponding to the

Line 4053: ' SELECT NVL((select org_information13 FROM hr_organization_information '||

4049:
4050: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN');
4051:
4052: build_sql(sqlstr,l_cntr_sql,
4053: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
4054: 'WHERE org_information_context = ''HR_SELF_SERVICE_ORG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
4055: build_sql(sqlstr,l_cntr_sql,
4056: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');
4057: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN ');

Line 4059: ' SELECT NVL((select org_information13 FROM hr_organization_information '||

4055: build_sql(sqlstr,l_cntr_sql,
4056: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');
4057: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN ');
4058: build_sql(sqlstr,l_cntr_sql,
4059: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
4060: 'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
4061: build_sql(sqlstr,l_cntr_sql,
4062: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL;');
4063: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN ');

Line 4583: FROM hr_organization_information hoi

4579:
4580: CURSOR get_exclusion_set_id(cp_business_group_id NUMBER)
4581: IS
4582: SELECT org_information7
4583: FROM hr_organization_information hoi
4584: WHERE hoi.organization_id = cp_business_group_id
4585: AND hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
4586: AND org_information1 = 'SIMPAYSLIP';
4587: