APPS.PAY_CN_AUDIT_XMLGEN dependencies on HR_ORGANIZATION_INFORMATION

Line 488: FROM hr_organization_information hoi

484: SELECT DISTINCT pap.payroll_name payroll_name,
485: fnd_number.canonical_to_number(hoi.org_information3) element_id,
486: nvl(petl.reporting_name,petl.element_name) element_name,
487: get_cost_alloc_key_flex(hoi.org_information3) exp_cat_code
488: FROM hr_organization_information hoi
489: ,hr_organization_units hou
490: ,pay_payrolls_f pap
491: ,pay_element_types_f_tl petl
492: ,pay_element_types_f pet

Line 523: FROM hr_organization_information hoi

519: SELECT DISTINCT pap.payroll_name payroll_name,
520: fnd_number.canonical_to_number(hoi.org_information2) element_id,
521: nvl(PBT_TL.REPORTING_NAME,PBT_TL.BALANCE_NAME) element_name,
522: 'X' exp_cat_code
523: FROM hr_organization_information hoi
524: ,hr_organization_units hou
525: ,pay_payrolls_f pap
526: ,PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
527: WHERE hoi.org_information_context = 'PER_CNAO_BAL_INFO'

Line 890: hr_organization_information hoi,

886: WHERE paf.person_id = ppf.person_id
887: AND paf.assignment_id = p_assignment_id
888: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
889: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
890: hr_organization_information hoi,
891: hr_organization_units hou,
892: pay_element_types_f_tl petl,
893: pay_element_types_f pet
894: where action_context_id = p_action_context_id

Line 932: hr_organization_information hoi,

928: WHERE paf.person_id = ppf.person_id
929: AND paf.assignment_id = p_assignment_id
930: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
931: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
932: hr_organization_information hoi,
933: hr_organization_units hou,
934: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
935: where action_context_id = p_action_context_id
936: and pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'

Line 938: from hr_organization_information h

934: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
935: where action_context_id = p_action_context_id
936: and pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
937: and pai.action_information4 = (select nvl(h.ORG_INFORMATION7,PBT_TL.BALANCE_NAME)
938: from hr_organization_information h
939: where h.org_information_context = 'Business Group:Payslip Info'
940: and h.organization_id = g_bg_id
941: and h.ORG_INFORMATION1 = 'BALANCE'
942: and h.ORG_INFORMATION4 = PBT_TL.BALANCE_TYPE_ID

Line 983: hr_organization_information hoi,

979: WHERE paf.person_id = ppf.person_id
980: AND paf.assignment_id = p_assignment_id
981: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
982: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
983: hr_organization_information hoi,
984: hr_organization_units hou,
985: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
986: where action_context_id = p_action_context_id
987: and pai.action_information_category = 'APAC BALANCES'

Line 1176: FROM hr_organization_information hoi

1172:
1173: CURSOR gen_xml_opt_soe_min
1174: IS
1175: SELECT hoi.org_information16
1176: FROM hr_organization_information hoi
1177: ,hr_organization_units hou
1178: WHERE hoi.org_information_context = 'PER_CORPORATE_INFO_CN'
1179: AND hou.organization_id = hoi.organization_id
1180: AND hou.business_group_id = g_bg_id

Line 1346: from HR_ORGANIZATION_INFORMATION

1342:
1343: /* cursor to get cost allocation segment number */
1344: CURSOR c_get_cost_seg IS
1345: select ORG_INFORMATION2
1346: from HR_ORGANIZATION_INFORMATION
1347: where ORG_INFORMATION_CONTEXT='PER_CNAO_EXPEND_CODE_INFO'
1348: and ORGANIZATION_ID = g_bg_id;
1349:
1350: /* cursor to fetch the expense category code segment*/