APPS.PAY_NZ_CEC_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 26: function PAY_NZ_GET_BAL_VALUE(p_assignment_id IN per_assignments_f.assignment_id%type,

22: -- Start Date and End Date Parameters for a defined balance id .
23: -- This function gets called from PAYNZCECETC.xml
24: --------------------------------------------------------------------
25:
26: function PAY_NZ_GET_BAL_VALUE(p_assignment_id IN per_assignments_f.assignment_id%type,
27: p_def_bal_id IN pay_defined_balances.defined_balance_id%type,
28: p_start_date IN date,
29: p_end_date IN date)
30: return number is

Line 32: Cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,p_start_date date,p_end_date date) is

28: p_start_date IN date,
29: p_end_date IN date)
30: return number is
31:
32: Cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,p_start_date date,p_end_date date) is
33: select paa.assignment_action_id
34: from pay_assignment_actions paa,
35: pay_payroll_actions ppa
36: where ppa.action_status ='C'