APPS.PAY_DK_MIA_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

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

35: p_parameter_string IN VARCHAR2
36: ,p_token IN VARCHAR2
37: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
38: IS
39: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
40: l_start_pos NUMBER;
41: l_delimiter varchar2(1);
42: l_proc VARCHAR2(60);
43:

Line 82: FROM pay_payroll_actions

78: ,p_token_name VARCHAR2) RETURN VARCHAR2 AS
79:
80: CURSOR csr_parameter_info(p_pact_id IN NUMBER) IS
81: SELECT legislative_parameters
82: FROM pay_payroll_actions
83: WHERE payroll_action_id = p_pact_id;
84:
85: l_token_value VARCHAR2(50);
86: l_parameter pay_payroll_actions.legislative_parameters%TYPE ;

Line 86: l_parameter pay_payroll_actions.legislative_parameters%TYPE ;

82: FROM pay_payroll_actions
83: WHERE payroll_action_id = p_pact_id;
84:
85: l_token_value VARCHAR2(50);
86: l_parameter pay_payroll_actions.legislative_parameters%TYPE ;
87: l_delimiter varchar2(1);
88: l_start_pos NUMBER;
89:
90: BEGIN

Line 140: select effective_date from pay_payroll_actions

136: ,p_end_date OUT NOCOPY VARCHAR2
137: ,p_direct_dd_date OUT NOCOPY VARCHAR2)RETURN VARCHAR2 AS
138:
139: cursor csr_get_eff_date(l_payroll_action_id IN NUMBER) is
140: select effective_date from pay_payroll_actions
141: where payroll_action_id = l_payroll_action_id;
142:
143: cursor csr_get_period_dates(l_payroll_id IN NUMBER, l_effective_date IN DATE) is
144: select to_char(start_date,'YYYYMMDD'), to_char(end_date,'YYYYMMDD'), to_char(default_dd_date,'YYYYMMDD')

Line 185: select effective_date from pay_payroll_actions

181: p_payroll_id IN VARCHAR2
182: ,p_payroll_action_id IN VARCHAR2)RETURN VARCHAR2 AS
183:
184: cursor csr_get_eff_date(l_payroll_action_id IN NUMBER) is
185: select effective_date from pay_payroll_actions
186: where payroll_action_id = l_payroll_action_id;
187:
188: cursor csr_get_payroll_period(l_payroll_id IN NUMBER, l_effective_date IN DATE) is
189: select period_name,period_num

Line 337: FROM pay_payroll_actions

333:
334: FUNCTION get_business_group_id(p_payroll_action_id IN number) RETURN NUMBER as
335: CURSOR csr_get_bg_id(p_payroll_action_id number) is
336: SELECT business_group_id
337: FROM pay_payroll_actions
338: WHERE payroll_action_id = p_payroll_action_id;
339:
340: l_bg_id NUMBER(15);
341:

Line 357: FROM pay_payroll_actions

353: p_effective_date IN DATE) RETURN VARCHAR2 as
354:
355: CURSOR csr_get_dd_date(p_payroll_id NUMBER,p_effective_date DATE) is
356: SELECT TO_CHAR(to_date(substr(legislative_parameters,instr(legislative_parameters,'=')+1,10),'YYYY/MM/DD'),'YYYYMMDD')
357: FROM pay_payroll_actions
358: where payroll_action_id = (select min(payroll_action_id) from pay_payroll_actions
359: where payroll_id = p_payroll_id
360: and action_type ='M'
361: AND action_status ='C'

Line 358: where payroll_action_id = (select min(payroll_action_id) from pay_payroll_actions

354:
355: CURSOR csr_get_dd_date(p_payroll_id NUMBER,p_effective_date DATE) is
356: SELECT TO_CHAR(to_date(substr(legislative_parameters,instr(legislative_parameters,'=')+1,10),'YYYY/MM/DD'),'YYYYMMDD')
357: FROM pay_payroll_actions
358: where payroll_action_id = (select min(payroll_action_id) from pay_payroll_actions
359: where payroll_id = p_payroll_id
360: and action_type ='M'
361: AND action_status ='C'
362: AND p_effective_date BETWEEN start_date AND effective_date);