APPS.PAY_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 166: ,pay_payroll_actions ppa

162: ,c_cs_token VARCHAR2
163: ,c_legislation_code VARCHAR2) IS
164: SELECT 'Y'
165: FROM pay_assignment_actions paa
166: ,pay_payroll_actions ppa
167: ,hr_lookups hrl
168: ,pay_action_information pai
169: ,per_time_periods ptp
170: WHERE paa.assignment_id = c_assignment_id

Line 201: ,pay_payroll_actions ppa

197: ,c_legislation_code VARCHAR2
198: ,c_assignment_set_id NUMBER ) IS
199: SELECT 'Y'
200: FROM pay_assignment_actions paa
201: ,pay_payroll_actions ppa
202: ,hr_lookups hrl
203: ,hr_assignment_set_amendments hasa
204: ,pay_action_information pai
205: ,per_time_periods ptp

Line 359: l_actid pay_payroll_actions.payroll_action_id%TYPE;

355: --------------------------------------------------------------------------------
356: PROCEDURE xml_asg IS
357: l_xml BLOB;
358: --
359: l_actid pay_payroll_actions.payroll_action_id%TYPE;
360: l_payroll_id NUMBER;
361: l_consolidation_set_id NUMBER;
362: l_start_date VARCHAR2(20);
363: l_end_date VARCHAR2(20);

Line 394: ,pay_payroll_actions ppa

390: SELECT pai.action_context_id
391: FROM pay_temp_object_actions ptoa
392: ,pay_action_information pai
393: ,pay_assignment_Actions paa
394: ,pay_payroll_actions ppa
395: ,hr_lookups hrl
396: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
397: AND ptoa.object_id = paa.assignment_id
398: AND paa.payroll_action_id = ppa.payroll_action_id