APPS.PQP_EXCP_RPT dependencies on PAY_PAYROLLS_F

Line 48: p_payroll_id pay_payrolls_f.payroll_id%TYPE,

44: --
45: -- Cursor to get the payroll name
46: --
47: CURSOR c_get_payroll_name(
48: p_payroll_id pay_payrolls_f.payroll_id%TYPE,
49: p_consolidation_set_id pay_payrolls_f.consolidation_set_id%TYPE,
50: p_business_group_id pay_payrolls_f.business_group_id%TYPE,
51: p_date DATE
52: )

Line 49: p_consolidation_set_id pay_payrolls_f.consolidation_set_id%TYPE,

45: -- Cursor to get the payroll name
46: --
47: CURSOR c_get_payroll_name(
48: p_payroll_id pay_payrolls_f.payroll_id%TYPE,
49: p_consolidation_set_id pay_payrolls_f.consolidation_set_id%TYPE,
50: p_business_group_id pay_payrolls_f.business_group_id%TYPE,
51: p_date DATE
52: )
53: IS

Line 50: p_business_group_id pay_payrolls_f.business_group_id%TYPE,

46: --
47: CURSOR c_get_payroll_name(
48: p_payroll_id pay_payrolls_f.payroll_id%TYPE,
49: p_consolidation_set_id pay_payrolls_f.consolidation_set_id%TYPE,
50: p_business_group_id pay_payrolls_f.business_group_id%TYPE,
51: p_date DATE
52: )
53: IS
54: SELECT payroll_name

Line 55: FROM pay_payrolls_f

51: p_date DATE
52: )
53: IS
54: SELECT payroll_name
55: FROM pay_payrolls_f
56: WHERE payroll_id=p_payroll_id
57: AND consolidation_set_id=p_consolidation_set_id
58: AND (business_group_id = p_business_group_id
59: OR business_group_id IS NULL)

Line 243: l_payroll_id_old pay_payrolls_f.payroll_id%TYPE;

239:
240: --
241: -- Variables used to keep backup (old/Previous) values
242: --
243: l_payroll_id_old pay_payrolls_f.payroll_id%TYPE;
244: l_consolidation_set_id_old pay_consolidation_sets.consolidation_set_id%TYPE;
245: l_balance_type_id_old pay_balance_types.balance_type_id%TYPE;
246: l_business_group_id_old pqp_exception_reports.business_group_id%TYPE;
247: l_report_id_old pqp_exception_reports.exception_report_id%TYPE;

Line 252: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

248:
249: --
250: -- Local Variables
251: --
252: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
253: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%TYPE;
254: l_balance_name pay_balance_types.balance_name%TYPE;
255: l_dimension_id pqp_exception_reports.balance_dimension_id%TYPE;
256: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;