DBA Data[Home] [Help]

APPS.PAY_CC_PROCESS_UTILS dependencies on PAY_CORE_UTILS

Line 28: pay_core_utils.get_parameter(''PAYROLL_ID'',

24: per_assignments_f asg,
25: pay_payroll_actions pa1
26: where pa1.payroll_action_id = :payroll_action_id
27: and asg.payroll_id =
28: pay_core_utils.get_parameter(''PAYROLL_ID'',
29: pa1.legislative_parameters)
30: and pa1.effective_date < asg.effective_end_date
31: order by asg.person_id';
32: --

Line 76: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters)

72: --
73:
74: CURSOR csr_act_info(cp_actid number) is
75: select
76: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters)
77: from pay_payroll_actions ppa
78: where ppa.payroll_action_id = cp_actid;
79:
80:

Line 264: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters),

260:
261: cursor csr_act_info(cp_actid number) is
262: select
263: paa.assignment_id,
264: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters),
265: ppa.business_group_id
266: from pay_assignment_actions paa,
267: pay_payroll_actions ppa
268: where paa.payroll_action_id = ppa.payroll_action_id

Line 642: pay_core_utils.get_parameter('REMOVE_ACT',pa1.legislative_parameters),

638: is
639:
640: cursor csr_params(cp_pactid number) is
641: select
642: pay_core_utils.get_parameter('REMOVE_ACT',pa1.legislative_parameters),
643: pay_core_utils.get_parameter('PAYROLL_ID',pa1.legislative_parameters)
644: from pay_payroll_actions pa1
645: where pa1.payroll_action_id = cp_pactid;
646:

Line 643: pay_core_utils.get_parameter('PAYROLL_ID',pa1.legislative_parameters)

639:
640: cursor csr_params(cp_pactid number) is
641: select
642: pay_core_utils.get_parameter('REMOVE_ACT',pa1.legislative_parameters),
643: pay_core_utils.get_parameter('PAYROLL_ID',pa1.legislative_parameters)
644: from pay_payroll_actions pa1
645: where pa1.payroll_action_id = cp_pactid;
646:
647: l_remove_act varchar2(10);

Line 731: 'pay_core_utils.get_business_group',

727: --
728: pay_dyn_triggers.create_trg_initialisation(
729: p_table_name||'_ARU',
730: '1',
731: 'pay_core_utils.get_business_group',
732: 'F',
733: NULL
734: );
735: --

Line 778: 'pay_core_utils.get_legislation_code',

774: --
775: pay_dyn_triggers.create_trg_initialisation(
776: p_table_name||'_ARU',
777: '2',
778: 'pay_core_utils.get_legislation_code',
779: 'F',
780: NULL
781: );
782: --

Line 1507: ''pay_core_utils.get_business_group'',

1503: --
1504: proc := ' pay_dyn_triggers.create_trg_initialisation(
1505: '''||p_table_name||'_ARU'',
1506: ''1'',
1507: ''pay_core_utils.get_business_group'',
1508: ''F'',
1509: sysdate,
1510: NULL
1511: );

Line 1566: ''pay_core_utils.get_legislation_code'',

1562: --
1563: proc := ' pay_dyn_triggers.create_trg_initialisation(
1564: '''||p_table_name||'_ARU'',
1565: ''2'',
1566: ''pay_core_utils.get_legislation_code'',
1567: ''F'',
1568: sysdate,
1569: NULL
1570: );