APPS.PAY_NO_PAYSLIP_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 16: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

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

Line 49: -- GET_ALL_PARAMETERS Gets data from Legislative Parameters in Pay_payroll_actions

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

Line 76: FROM pay_payroll_actions ppa

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: --

Line 170: ,pay_payroll_actions ppa

166: ,c_cs_token VARCHAR2
167: ,c_legislation_code VARCHAR2) IS
168: SELECT 'Y'
169: FROM pay_assignment_actions paa
170: ,pay_payroll_actions ppa
171: ,hr_lookups hrl
172: ,pay_action_information pai
173: ,per_time_periods ptp
174: WHERE paa.assignment_id = c_assignment_id

Line 207: ,pay_payroll_actions ppa

203: ,c_legislation_code VARCHAR2
204: ,c_assignment_set_id NUMBER ) IS
205: SELECT 'Y'
206: FROM pay_assignment_actions paa
207: ,pay_payroll_actions ppa
208: ,hr_lookups hrl
209: ,hr_assignment_set_amendments hasa
210: ,pay_action_information pai
211: ,per_time_periods ptp

Line 409: l_actid pay_payroll_actions.payroll_action_id%TYPE;

405: --------------------------------------------------------------------------------
406: PROCEDURE xml_asg IS
407: l_xml BLOB;
408: --
409: l_actid pay_payroll_actions.payroll_action_id%TYPE;
410: l_payroll_id NUMBER;
411: l_consolidation_set_id NUMBER;
412: l_start_date VARCHAR2(20);
413: l_end_date VARCHAR2(20);

Line 439: ,pay_payroll_actions ppa

435: SELECT pai.action_context_id
436: FROM pay_temp_object_actions ptoa
437: ,pay_action_information pai
438: ,pay_assignment_Actions paa
439: ,pay_payroll_actions ppa
440: ,hr_lookups hrl
441: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
442: AND ptoa.object_id = paa.assignment_id
443: AND paa.payroll_action_id = ppa.payroll_action_id