[Home] [Help]
12: ,p_token IN VARCHAR2
13: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
14: IS
15: --
16: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
17: l_start_pos NUMBER;
18: l_delimiter varchar2(1) := ' ';
19: --
20: BEGIN
45: RETURN l_parameter;
46: END get_parameter;
47: --
48: -------------------------------------------------------------------------------
49: -- GET_ALL_PARAMETERS Gets data from Legislative Parameters in Pay_payroll_actions
50: -------------------------------------------------------------------------------
51: PROCEDURE get_all_parameters(p_payroll_action_id IN NUMBER
52: ,p_payroll_id OUT NOCOPY NUMBER
53: ,p_consolidation_set_id OUT NOCOPY NUMBER
72: ,get_parameter(ppa.legislative_parameters,'ASSIGNMENT_ID')
73: ,ppa.effective_date
74: ,ppa.business_group_id
75: ,pbg.legislation_code
76: FROM pay_payroll_actions ppa
77: ,per_business_groups pbg
78: WHERE ppa.payroll_action_id = c_payroll_action_id
79: AND ppa.business_group_id = pbg.business_group_id;
80: --
134: ,c_cs_token VARCHAR2
135: ,c_legislation_code VARCHAR2) IS
136: SELECT 'Y'
137: FROM pay_assignment_actions paa
138: ,pay_payroll_actions ppa
139: ,hr_lookups hrl
140: ,pay_action_information pai
141: ,per_time_periods ptp
142:
170: ,c_legislation_code VARCHAR2
171: ,c_assignment_set_id NUMBER ) IS
172: SELECT 'Y'
173: FROM pay_assignment_actions paa
174: ,pay_payroll_actions ppa
175: ,hr_assignment_set_amendments hasa
176: ,hr_lookups hrl
177: ,pay_action_information pai
178: ,per_time_periods ptp
356: IS
357: SELECT PAF.ASSIGNMENT_ID assignment_id
358: FROM PER_ALL_ASSIGNMENTS_F PAF,
359: PAY_ASSIGNMENT_ACTIONS PAA,
360: PAY_PAYROLL_ACTIONS PPA
361: WHERE PAF.payroll_id=p_payroll_id
362: AND PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
363: AND PAF.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID
364: AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE
545: --------------------------------------------------------------------------------
546: PROCEDURE xml_asg IS
547: l_xml BLOB;
548: --
549: l_actid pay_payroll_actions.payroll_action_id%TYPE;
550: l_payroll_id NUMBER;
551: l_consolidation_set_id NUMBER;
552: l_start_date VARCHAR2(20);
553: l_end_date VARCHAR2(20);
575: SELECT pai.action_context_id
576: FROM pay_temp_object_actions ptoa
577: ,pay_action_information pai
578: ,pay_assignment_Actions paa
579: ,pay_payroll_actions ppa
580: ,hr_lookups hrl
581: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
582: AND ptoa.object_id = paa.assignment_id
583: AND paa.payroll_action_id = ppa.payroll_action_id