APPS.PAY_KR_WF_SUBMIT_PROGRAM_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 16: p_business_group_id in pay_payroll_actions.business_group_id%type,

12: --
13: -- Bug 4859652
14: cursor csr_payroll_action_id(
15: p_prepayments_req_id in number,
16: p_business_group_id in pay_payroll_actions.business_group_id%type,
17: p_payroll_id in pay_payroll_actions.payroll_id%type
18: ) is
19: select payroll_action_id
20: from pay_payroll_actions

Line 17: p_payroll_id in pay_payroll_actions.payroll_id%type

13: -- Bug 4859652
14: cursor csr_payroll_action_id(
15: p_prepayments_req_id in number,
16: p_business_group_id in pay_payroll_actions.business_group_id%type,
17: p_payroll_id in pay_payroll_actions.payroll_id%type
18: ) is
19: select payroll_action_id
20: from pay_payroll_actions
21: where request_id = p_prepayments_req_id

Line 20: from pay_payroll_actions

16: p_business_group_id in pay_payroll_actions.business_group_id%type,
17: p_payroll_id in pay_payroll_actions.payroll_id%type
18: ) is
19: select payroll_action_id
20: from pay_payroll_actions
21: where request_id = p_prepayments_req_id
22: and business_group_id = p_business_group_id
23: and payroll_id = p_payroll_id
24: and action_type = 'P' ;

Line 29: from pay_payroll_actions ppa,

25: -- End of 4859652
26: --
27: cursor csr_run_type_period_name(p_run_type_period in number) is
28: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name
29: from pay_payroll_actions ppa,
30: pay_payroll_actions rppa,
31: pay_assignment_actions paa,
32: pay_assignment_actions rpaa,
33: pay_action_interlocks pai,

Line 30: pay_payroll_actions rppa,

26: --
27: cursor csr_run_type_period_name(p_run_type_period in number) is
28: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name
29: from pay_payroll_actions ppa,
30: pay_payroll_actions rppa,
31: pay_assignment_actions paa,
32: pay_assignment_actions rpaa,
33: pay_action_interlocks pai,
34: pay_run_types_f prt,

Line 61: l_prepayments_req_id pay_payroll_actions.request_id%TYPE ;

57: and paa_locked.assignment_action_id = pai_locking.locked_action_id)
58: and ppa.effective_date between prt.effective_start_date and prt.effective_end_date
59: and rppa.effective_date between ptp.start_date and ptp.end_date;
60: --
61: l_prepayments_req_id pay_payroll_actions.request_id%TYPE ;
62: l_business_group_id pay_payroll_actions.business_group_id%type ; -- Bug 4859652
63: l_payroll_id pay_payroll_actions.payroll_id%type ; -- Bug 4859652
64: --
65: begin

Line 62: l_business_group_id pay_payroll_actions.business_group_id%type ; -- Bug 4859652

58: and ppa.effective_date between prt.effective_start_date and prt.effective_end_date
59: and rppa.effective_date between ptp.start_date and ptp.end_date;
60: --
61: l_prepayments_req_id pay_payroll_actions.request_id%TYPE ;
62: l_business_group_id pay_payroll_actions.business_group_id%type ; -- Bug 4859652
63: l_payroll_id pay_payroll_actions.payroll_id%type ; -- Bug 4859652
64: --
65: begin
66: --

Line 63: l_payroll_id pay_payroll_actions.payroll_id%type ; -- Bug 4859652

59: and rppa.effective_date between ptp.start_date and ptp.end_date;
60: --
61: l_prepayments_req_id pay_payroll_actions.request_id%TYPE ;
62: l_business_group_id pay_payroll_actions.business_group_id%type ; -- Bug 4859652
63: l_payroll_id pay_payroll_actions.payroll_id%type ; -- Bug 4859652
64: --
65: begin
66: --
67: if g_debug then

Line 198: l_payroll_id pay_payroll_actions.payroll_id%type ; -- Bug 5042942

194: ln_complete number(9);
195: ln_error number(9);
196: ln_unprocessed number(9);
197: lb_to_get_counts boolean ;
198: l_payroll_id pay_payroll_actions.payroll_id%type ; -- Bug 5042942
199: l_action_completed boolean;
200: --
201: cursor asg_info_cur
202: is

Line 206: pay_payroll_actions ppa,

202: is
203: select count(paa.assignment_action_id) ASG_COUNT,
204: paa.action_status ASG_STATUS
205: from pay_assignment_actions paa,
206: pay_payroll_actions ppa,
207: per_business_groups pbg
208: where paa.payroll_action_id = ppa.payroll_action_id
209: and ppa.request_id = ln_req_id
210: and ppa.business_group_id = pbg.business_group_id