APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_PAYROLL_ACTIONS

Line 85: from pay_payroll_actions ppa

81: -- Cursor to get the payroll_action_id
82:
83: cursor csr_payroll_action_id (p_date_earned DATE ) is
84: select ppa.PAYROLL_ACTION_ID
85: from pay_payroll_actions ppa
86: ,pay_run_types_f prt
87: where ppa.RUN_TYPE_ID = prt.RUN_TYPE_ID
88: and prt.LEGISLATION_CODE = 'NO'
89: and prt.RUN_TYPE_NAME IN ('Main','Standard','Process Alone','Pay Separately')

Line 98: ,l_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type) is

94:
95:
96: -- Cursor to get the assignment_action_id and assignment_id
97: cursor csr_assignment_id (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
98: ,l_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type) is
99: select ASSIGNMENT_ID
100: ,ASSIGNMENT_ACTION_ID
101: from pay_assignment_actions
102: where PAYROLL_ACTION_ID = l_payroll_action_id

Line 130: (p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

126:
127: -- cursor to get the Local Units (LU) and Legal Employers (LE) of the current assignments
128:
129: cursor csr_get_lu_le
130: (p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
131: ,p_date_earned DATE ) is
132:
133: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
134: FROM pay_assignment_actions assact