DBA Data[Home] [Help]

APPS.PAY_NO_SC_ARCHIVE dependencies on PAY_NO_ARC_HOLIDAY_ENTITLEMENT

Line 68: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,

64: ,p_archive OUT NOCOPY VARCHAR2
65: ,p_effective_date OUT NOCOPY DATE
66: ) IS
67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
69: 'LEGAL_EMPLOYER')
70: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
71: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
72: ,effective_date

Line 70: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')

66: ) IS
67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
69: 'LEGAL_EMPLOYER')
70: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
71: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
72: ,effective_date
73: ,business_group_id
74: FROM pay_payroll_actions

Line 71: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')

67: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
68: SELECT PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,
69: 'LEGAL_EMPLOYER')
70: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'EMPLOYEEID')
71: ,PAY_NO_ARC_HOLIDAY_ENTITLEMENT.GET_PARAMETER(legislative_parameters,'ARCHIVE')
72: ,effective_date
73: ,business_group_id
74: FROM pay_payroll_actions
75: WHERE payroll_action_id = p_payroll_action_id;

Line 154: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */

150: -- Return cursor that selects no rows
151: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
152: END RANGE_CODE;
153:
154: /* ASSIGNMENT ACTION CODE PAY_NO_ARC_HOLIDAY_ENTITLEMENT.ASSIGNMENT_ACTION_CODE */
155:
156: PROCEDURE ASSIGNMENT_ACTION_CODE
157: (p_payroll_action_id IN NUMBER
158: ,p_start_person IN NUMBER