APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 523: l_org_information_context hr_organization_information.org_information_context%type;

519: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';
520: c_payment_type constant hr_lookups.lookup_code%type := 'F';
521: l_exists VARCHAR2(1);
522: l_organization_id number;
523: l_org_information_context hr_organization_information.org_information_context%type;
524: l_act_info_rec pay_emp_action_arch.act_info_rec;
525: l_result_value varchar2(255);
526: --
527: CURSOR csr_organization_info(

Line 531: FROM hr_organization_information

527: CURSOR csr_organization_info(
528: cp_organization_id NUMBER,
529: cp_org_info_context VARCHAR2) IS
530: SELECT 'Y'
531: FROM hr_organization_information
532: WHERE organization_id = cp_organization_id
533: AND org_information_context = cp_org_info_context;
534: --
535: CURSOR csr_eit_element(

Line 552: hr_organization_information hoi,

548: FROM pay_action_interlocks rpai, -- run interlock by archive assact
549: pay_assignment_actions rpaa, -- run assact
550: pay_payroll_actions rppa, -- run pact
551: pay_run_results prr,
552: hr_organization_information hoi,
553: pay_element_types_f pet,
554: pay_element_types_f_tl pettl,
555: pay_input_values_f piv,
556: pay_run_result_values prrv