[Home] [Help]
362: --
363: -- Declare cursor
364: --
365: -- In the following cursor statement add join(s) between
366: -- pay_batch_lines and PER_BUSINESS_GROUPS
367: -- so that the security_group_id for
368: -- the current business group context can be derived.
369: -- Remove this comment when the edit has been completed.
370: cursor csr_sec_grp is
368: -- the current business group context can be derived.
369: -- Remove this comment when the edit has been completed.
370: cursor csr_sec_grp is
371: select pbg.security_group_id
372: from per_business_groups pbg
373: , pay_batch_lines btl
374: , pay_batch_headers bth
375: where btl.batch_line_id = p_batch_line_id
376: and bth.batch_id = btl.batch_id
429: --
430: -- Declare cursor
431: --
432: -- In the following cursor statement add join(s) between
433: -- pay_batch_lines and PER_BUSINESS_GROUPS
434: -- so that the legislation_code for
435: -- the current business group context can be derived.
436: -- Remove this comment when the edit has been completed.
437: cursor csr_leg_code is
435: -- the current business group context can be derived.
436: -- Remove this comment when the edit has been completed.
437: cursor csr_leg_code is
438: select pbg.legislation_code
439: from per_business_groups pbg
440: , pay_batch_lines btl
441: , pay_batch_headers bth
442: where btl.batch_line_id = p_batch_line_id
443: and bth.batch_id = btl.batch_id
1053: where pbh.batch_id = c_batch_id;
1054:
1055: cursor csr_id_flex_num(c_business_group_id pay_batch_headers.business_group_id%type)is
1056: select cost_allocation_structure
1057: from per_business_groups
1058: where business_group_id= c_business_group_id;
1059:
1060: l_business_group_id pay_batch_headers.business_group_id%type;
1061: l_id_flex_num pay_cost_allocation_keyflex.id_flex_num%type;