DBA Data[Home] [Help]

APPS.PER_JP_WRKREG_REPORT_PKG dependencies on FND_NUMBER

Line 268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id

264: IS
265: --
266: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id

Line 269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid

265: --
266: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id

Line 725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));

721: INTO lc_legislative_parameters
722: FROM pay_payroll_actions
723: WHERE payroll_action_id = p_payroll_action_id;
724: --
725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
727: --
728: g_mag_payroll_action_id:=p_payroll_action_id;
729: gb_debug :=hr_utility.debug_enabled ;

Line 726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));

722: FROM pay_payroll_actions
723: WHERE payroll_action_id = p_payroll_action_id;
724: --
725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
727: --
728: g_mag_payroll_action_id:=p_payroll_action_id;
729: gb_debug :=hr_utility.debug_enabled ;
730: --

Line 1670: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));

1666: INTO lc_legislative_parameters
1667: FROM pay_payroll_actions
1668: WHERE payroll_action_id = ln_cur_pact;
1669: --
1670: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
1671: --
1672: SELECT PAA1.assignment_action_id
1673: INTO ln_old_assact_id
1674: FROM pay_assignment_actions PAA,