eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_US_SRS_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 132: from pay_payrolls_f

128:
129: Cursor csr_payroll_name (c_payroll_id In per_all_assignments_f.payroll_id%TYPE
130: ,c_effective_date In date ) Is
131: Select payroll_name, period_type
132: from pay_payrolls_f
133: Where c_effective_date Between effective_start_date
134: and effective_end_date
135: and payroll_id = c_payroll_id;
136:

Line 140: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

136:
137: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
138: l_start_date date;
139: l_end_date date;
140: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
141: l_period_type pay_payrolls_f.period_type%TYPE;
142: l_proc_name varchar2(150) := g_proc_name ||'.Get_Payroll_Name';
143: l_error varchar2(500);
144: -- nocopy changes tmehra

Line 141: l_period_type pay_payrolls_f.period_type%TYPE;

137: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
138: l_start_date date;
139: l_end_date date;
140: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
141: l_period_type pay_payrolls_f.period_type%TYPE;
142: l_proc_name varchar2(150) := g_proc_name ||'.Get_Payroll_Name';
143: l_error varchar2(500);
144: -- nocopy changes tmehra
145: l_payroll_name_nc pay_payrolls_f.payroll_name%TYPE;

Line 145: l_payroll_name_nc pay_payrolls_f.payroll_name%TYPE;

141: l_period_type pay_payrolls_f.period_type%TYPE;
142: l_proc_name varchar2(150) := g_proc_name ||'.Get_Payroll_Name';
143: l_error varchar2(500);
144: -- nocopy changes tmehra
145: l_payroll_name_nc pay_payrolls_f.payroll_name%TYPE;
146: Begin
147: hr_utility.set_location('Entering: '||l_proc_name, 5);
148:
149: -- nocopy changes tmehra

Line 760: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

756: -- ===============================================================================
757: Function Check_Valid_Payroll ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
758: ,p_effective_date In Date) Return Varchar2 Is
759:
760: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
761: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
762: l_period_type pay_payrolls_f.period_type%TYPE;
763: l_return_value pay_payrolls_f.payroll_name%TYPE;
764: l_proc_name varchar2(150) := g_proc_name||'Check_Valid_Payroll';

Line 761: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

757: Function Check_Valid_Payroll ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
758: ,p_effective_date In Date) Return Varchar2 Is
759:
760: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
761: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
762: l_period_type pay_payrolls_f.period_type%TYPE;
763: l_return_value pay_payrolls_f.payroll_name%TYPE;
764: l_proc_name varchar2(150) := g_proc_name||'Check_Valid_Payroll';
765: l_error varchar2(500);

Line 762: l_period_type pay_payrolls_f.period_type%TYPE;

758: ,p_effective_date In Date) Return Varchar2 Is
759:
760: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
761: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
762: l_period_type pay_payrolls_f.period_type%TYPE;
763: l_return_value pay_payrolls_f.payroll_name%TYPE;
764: l_proc_name varchar2(150) := g_proc_name||'Check_Valid_Payroll';
765: l_error varchar2(500);
766:

Line 763: l_return_value pay_payrolls_f.payroll_name%TYPE;

759:
760: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
761: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
762: l_period_type pay_payrolls_f.period_type%TYPE;
763: l_return_value pay_payrolls_f.payroll_name%TYPE;
764: l_proc_name varchar2(150) := g_proc_name||'Check_Valid_Payroll';
765: l_error varchar2(500);
766:
767: Begin