APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PAY_PAYROLLS_F

Line 671: CURSOR csr_payroll_period(csr_v_payroll_id pay_payrolls_f.payroll_id%type)

667: AND hl.LOOKUP_TYPE='SE_WORKING_HOUR_TYPE'
668: AND hl.lookup_code=aei_information1;
669:
670: /* Payroll period type */
671: CURSOR csr_payroll_period(csr_v_payroll_id pay_payrolls_f.payroll_id%type)
672: IS
673: SELECT period_type
674: FROM pay_payrolls_f
675: WHERE payroll_id=csr_v_payroll_id;

Line 674: FROM pay_payrolls_f

670: /* Payroll period type */
671: CURSOR csr_payroll_period(csr_v_payroll_id pay_payrolls_f.payroll_id%type)
672: IS
673: SELECT period_type
674: FROM pay_payrolls_f
675: WHERE payroll_id=csr_v_payroll_id;
676:
677: /*Balances under the Balance Category*/
678: CURSOR csr_balances(csr_v_business_group_id hr_organization_units.business_group_id%type,

Line 810: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

806: l_person_id per_all_people_f.person_id%TYPE;
807: l_ssyk hr_lookups.lookup_code%TYPE;
808: l_ssyk_code hr_lookups.meaning%TYPE;
809: l_association_code varchar2(10);
810: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
811: l_work_type varchar2(250);
812: l_salary_type Number(1);
813: l_payroll_type pay_payrolls_f.payroll_type%TYPE;
814:

Line 813: l_payroll_type pay_payrolls_f.payroll_type%TYPE;

809: l_association_code varchar2(10);
810: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
811: l_work_type varchar2(250);
812: l_salary_type Number(1);
813: l_payroll_type pay_payrolls_f.payroll_type%TYPE;
814:
815:
816: l_001_steering_code NUMBER:=0;
817: l_002_steering_code NUMBER:=0;