APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on PAY_ALL_PAYROLLS_F

Line 97: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

93: -- Desctiption: This function gets id of payroll name parameter
94: ---------------------------------------------------------------------------
95: FUNCTION get_param_payroll_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
96: --
97: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
98: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: --
100: CURSOR get_payroll_id IS
101: SELECT payroll_id

Line 98: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

94: ---------------------------------------------------------------------------
95: FUNCTION get_param_payroll_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
96: --
97: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
98: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: --
100: CURSOR get_payroll_id IS
101: SELECT payroll_id
102: FROM pay_all_payrolls_f

Line 102: FROM pay_all_payrolls_f

98: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: --
100: CURSOR get_payroll_id IS
101: SELECT payroll_id
102: FROM pay_all_payrolls_f
103: WHERE payroll_name = l_payroll_name
104: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
105: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
106: --

Line 986: FROM pay_all_payrolls_f pp,

982: l_max_end_date DATE;
983: --
984: CURSOR get_asg_details(p_asg_id IN NUMBER) IS
985: SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
986: FROM pay_all_payrolls_f pp,
987: per_all_assignments_f asg,
988: hr_soft_coding_keyflex flex
989: WHERE asg.assignment_id = p_asg_id
990: AND asg.payroll_id = pp.payroll_id