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 812: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

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

Line 815: l_payroll_type pay_payrolls_f.payroll_type%TYPE;

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