DBA Data[Home] [Help]

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 582: From pay_all_payrolls_f pr

578: And Rate.ELIG_PER_ELCTBL_CHC_ID(+) = Elct.ELIG_PER_ELCTBL_CHC_ID;
579: --
580: Cursor csr_payroll_freq (p_payroll_id in number) is
581: Select pr.period_type
582: From pay_all_payrolls_f pr
583: Where pr.payroll_id = p_payroll_id
584: and p_Effective_Date
585: Between pr.Effective_Start_date and pr.Effective_End_Date;
586: --