APPS.PQH_EMPLOYEE_SALARY dependencies on PAY_ALL_PAYROLLS_F

Line 83: From per_time_period_types pt, pay_all_payrolls_f pr

79: Between pgm.Effective_Start_date and pgm.Effective_End_Date;
80: --
81: Cursor csr_ann_sal (p_sal in number, p_payroll_id in number) is
82: Select pr.period_type, (p_sal * pt.number_per_fiscal_year) annual_salary
83: From per_time_period_types pt, pay_all_payrolls_f pr
84: Where pr.payroll_id = p_payroll_id
85: and p_Effective_Date
86: Between pr.Effective_Start_date and pr.Effective_End_Date
87: and pr.period_type = pt.period_type;

Line 504: From pay_all_payrolls_f pr

500: And Rate.ELIG_PER_ELCTBL_CHC_ID(+) = Elct.ELIG_PER_ELCTBL_CHC_ID;
501: --
502: Cursor csr_payroll_freq (p_payroll_id in number) is
503: Select pr.period_type
504: From pay_all_payrolls_f pr
505: Where pr.payroll_id = p_payroll_id
506: and p_Effective_Date
507: Between pr.Effective_Start_date and pr.Effective_End_Date;
508: --