eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1063: p_business_group_id in hr_organization_units.business_group_id%type,

1059: ---------------------------------------------------------------------------
1060: procedure archive_balances
1061: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1062: p_person_id in per_all_people_f.person_id%type,
1063: p_business_group_id in hr_organization_units.business_group_id%type,
1064: p_tax_unit_id in ff_archive_item_contexts.context%type,
1065: p_basis_year in varchar2 )
1066: is
1067: v_run_ass_action_id pay_assignment_actions.assignment_action_id%type;

Line 1131: c_business_group_id hr_organization_units.business_group_id%type,

1127: -- Cursor month_year_action_sequence
1128: ---------------------------------------------------------------------------------------------------
1129: cursor month_year_action_sequence
1130: ( c_person_id per_all_people_f.person_id%type,
1131: c_business_group_id hr_organization_units.business_group_id%type,
1132: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1133: c_basis_year varchar2 )
1134: is
1135: select /*+ ORDERED USE_NL(pacmax) */

Line 1156: c_business_group_id hr_organization_units.business_group_id%type,

1152: -- cursor month_year_action
1153: ---------------------------------------------------------------------------------------------------
1154: cursor month_year_action
1155: ( c_person_id per_all_people_f.person_id%type,
1156: c_business_group_id hr_organization_units.business_group_id%type,
1157: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
1158: c_basis_year varchar2,
1159: c_action_sequence pay_assignment_actions.action_sequence%type )
1160: is

Line 1756: p_business_group_id in hr_organization_units.business_group_id%type,

1752: ---------------------------------------------------------------------------
1753: procedure archive_balance_dates
1754: ( p_person_id in per_all_people_f.person_id%TYPE,
1755: p_basis_year in varchar2,
1756: p_business_group_id in hr_organization_units.business_group_id%type,
1757: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1758: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,
1759: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type )
1760: is

Line 1812: c_business_group_id hr_organization_units.business_group_id%type )

1808: ---------------------------------------------------------------------------
1809: cursor get_max_assactid( c_prev_ass_id per_all_assignments_f.assignment_id%TYPE ,
1810: c_basis_year varchar2,
1811: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1812: c_business_group_id hr_organization_units.business_group_id%type )
1813: is
1814: select assact1.assignment_action_id
1815: from pay_assignment_actions assact1,
1816: pay_payroll_actions pact1,

Line 1846: p_business_group_id in hr_organization_units.business_group_id%type,

1842: --
1843: procedure get_balance_dates ( p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
1844: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
1845: p_balance_name in pay_balance_types.balance_name%type,
1846: p_business_group_id in hr_organization_units.business_group_id%type,
1847: p_date_from out nocopy ff_archive_items.value%type,
1848: p_date_to out nocopy ff_archive_items.value%type,
1849: p_no_of_times out nocopy number )
1850: is

Line 1940: c_business_group_id hr_organization_units.business_group_id%type )

1936: and pbd.legislation_code = 'SG';
1937:
1938: --
1939: cursor get_balance_status(c_def_balance_id pay_defined_balances.defined_balance_id%type,
1940: c_business_group_id hr_organization_units.business_group_id%type )
1941: is
1942: select run_balance_status
1943: from pay_balance_validation
1944: where defined_balance_id = c_def_balance_id

Line 2487: p_business_group_id in hr_organization_units.business_group_id%type,

2483: -- Copies the Org Developer DF route code to get Legal Entity information.
2484: ---------------------------------------------------------------------------
2485: procedure archive_org_info
2486: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2487: p_business_group_id in hr_organization_units.business_group_id%type,
2488: p_legal_entity_id in hr_organization_units.organization_id%type,
2489: p_person_id in per_all_people_f.person_id%type,
2490: p_basis_start in date,
2491: p_basis_end in date)

Line 2488: p_legal_entity_id in hr_organization_units.organization_id%type,

2484: ---------------------------------------------------------------------------
2485: procedure archive_org_info
2486: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2487: p_business_group_id in hr_organization_units.business_group_id%type,
2488: p_legal_entity_id in hr_organization_units.organization_id%type,
2489: p_person_id in per_all_people_f.person_id%type,
2490: p_basis_start in date,
2491: p_basis_end in date)
2492: is

Line 2516: ( c_business_group_id hr_organization_units.business_group_id%type,

2512:
2513:
2514: --
2515: cursor org_info
2516: ( c_business_group_id hr_organization_units.business_group_id%type,
2517: c_legal_entity_id hr_organization_units.organization_id%type)
2518: is
2519: select target.org_information1,
2520: target.org_information4,

Line 2517: c_legal_entity_id hr_organization_units.organization_id%type)

2513:
2514: --
2515: cursor org_info
2516: ( c_business_group_id hr_organization_units.business_group_id%type,
2517: c_legal_entity_id hr_organization_units.organization_id%type)
2518: is
2519: select target.org_information1,
2520: target.org_information4,
2521: target.org_information10,

Line 2530: from hr_organization_units org,

2526: target.org_information15,
2527: target.org_information17,
2528: target.org_information18,
2529: target.org_information8
2530: from hr_organization_units org,
2531: hr_organization_information target,
2532: hr_soft_coding_keyflex scl
2533: where org.business_group_id = c_business_group_id
2534: and org.organization_id = c_legal_entity_id

Line 2541: ( c_business_group_id hr_organization_units.business_group_id%type,

2537: and to_char(org.organization_id) = scl.segment1;
2538: --
2539: -- Added for bug 5435088
2540: cursor org_info2
2541: ( c_business_group_id hr_organization_units.business_group_id%type,
2542: c_legal_entity_id hr_organization_units.organization_id%type)
2543: is
2544: select target.org_information5,
2545: target.org_information7

Line 2542: c_legal_entity_id hr_organization_units.organization_id%type)

2538: --
2539: -- Added for bug 5435088
2540: cursor org_info2
2541: ( c_business_group_id hr_organization_units.business_group_id%type,
2542: c_legal_entity_id hr_organization_units.organization_id%type)
2543: is
2544: select target.org_information5,
2545: target.org_information7
2546: from hr_organization_units org,

Line 2546: from hr_organization_units org,

2542: c_legal_entity_id hr_organization_units.organization_id%type)
2543: is
2544: select target.org_information5,
2545: target.org_information7
2546: from hr_organization_units org,
2547: hr_organization_information target,
2548: hr_soft_coding_keyflex scl
2549: where org.business_group_id = c_business_group_id
2550: and org.organization_id = c_legal_entity_id

Line 2724: p_business_group_id in hr_organization_units.business_group_id%type,

2720: -- Bug 5435088, Added for payroll date
2721: --------------------------------------------------------------------------
2722: procedure archive_payroll_date
2723: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2724: p_business_group_id in hr_organization_units.business_group_id%type,
2725: p_legal_entity_id in hr_organization_units.organization_id%type,
2726: p_person_id in per_all_people_f.person_id%type,
2727: p_basis_year in varchar2) is
2728:

Line 2725: p_legal_entity_id in hr_organization_units.organization_id%type,

2721: --------------------------------------------------------------------------
2722: procedure archive_payroll_date
2723: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2724: p_business_group_id in hr_organization_units.business_group_id%type,
2725: p_legal_entity_id in hr_organization_units.organization_id%type,
2726: p_person_id in per_all_people_f.person_id%type,
2727: p_basis_year in varchar2) is
2728:
2729: v_payroll_date varchar2(30);

Line 2731: ( c_business_group_id hr_organization_units.business_group_id%type,

2727: p_basis_year in varchar2) is
2728:
2729: v_payroll_date varchar2(30);
2730: cursor payroll_date
2731: ( c_business_group_id hr_organization_units.business_group_id%type,
2732: c_legal_entity_id hr_organization_units.organization_id%type,
2733: c_person_id per_all_people_f.person_id%type,
2734: c_basis_year varchar2)
2735: is

Line 2732: c_legal_entity_id hr_organization_units.organization_id%type,

2728:
2729: v_payroll_date varchar2(30);
2730: cursor payroll_date
2731: ( c_business_group_id hr_organization_units.business_group_id%type,
2732: c_legal_entity_id hr_organization_units.organization_id%type,
2733: c_person_id per_all_people_f.person_id%type,
2734: c_basis_year varchar2)
2735: is
2736: select fnd_date.date_to_canonical(max(ppamax.effective_date))

Line 3259: p_legal_entity_id in hr_organization_units.organization_id%type,

3255: procedure archive_assignment_eits
3256: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3257: p_person_id in per_all_people_f.person_id%type,
3258: p_assignment_id in per_all_assignments_f.assignment_id%type,
3259: p_legal_entity_id in hr_organization_units.organization_id%type,
3260: p_basis_start in date,
3261: p_basis_end in date )
3262: is
3263: --

Line 3278: c_legal_entity_id hr_organization_units.organization_id%type,

3274: ---------------------------------------------------------------------------
3275: cursor assignment_eits
3276: ( c_person_id per_all_people_f.person_id%type,
3277: c_assignment_id per_assignments_f.assignment_id%type,
3278: c_legal_entity_id hr_organization_units.organization_id%type,
3279: c_basis_start date,
3280: c_basis_end date )
3281: is
3282: select /*+ USE_NL(aei) */

Line 3327: p_legal_entity_id in hr_organization_units.organization_id%type,

3323: procedure archive_ass_bonus_date_eits
3324: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3325: p_person_id in per_all_people_f.person_id%type,
3326: p_assignment_id in per_all_assignments_f.assignment_id%type,
3327: p_legal_entity_id in hr_organization_units.organization_id%type,
3328: p_basis_start in date,
3329: p_basis_end in date )
3330: is
3331: --

Line 3338: c_legal_entity_id hr_organization_units.organization_id%type,

3334:
3335: cursor ass_bonus_date_eits
3336: ( c_person_id per_all_people_f.person_id%type,
3337: c_assignment_id per_assignments_f.assignment_id%type,
3338: c_legal_entity_id hr_organization_units.organization_id%type,
3339: c_basis_start date,
3340: c_basis_end date )
3341: is
3342: select /*+ USE_NL(aei) */

Line 3392: p_legal_entity_id in hr_organization_units.organization_id%type,

3388: procedure archive_ass_payment_method
3389: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3390: p_person_id in per_all_people_f.person_id%type,
3391: p_assignment_id in per_all_assignments_f.assignment_id%type,
3392: p_legal_entity_id in hr_organization_units.organization_id%type,
3393: p_basis_start in date,
3394: p_basis_end in date)
3395: is
3396: --

Line 3403: c_legal_entity_id hr_organization_units.organization_id%type,

3399:
3400: cursor ass_payment_method
3401: ( c_person_id per_all_people_f.person_id%type,
3402: c_assignment_id per_assignments_f.assignment_id%type,
3403: c_legal_entity_id hr_organization_units.organization_id%type,
3404: c_basis_start in date,
3405: c_basis_end in date)
3406: is
3407:

Line 3469: p_legal_entity_id in hr_organization_units.organization_id%type,

3465: procedure archive_job_designation
3466: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3467: p_person_id in per_all_people_f.person_id%type,
3468: p_assignment_id in per_all_assignments_f.assignment_id%type,
3469: p_legal_entity_id in hr_organization_units.organization_id%type,
3470: p_basis_start in date,
3471: p_basis_end in date,
3472: p_er_designation_type in hr_organization_information.org_information17%type,
3473: p_er_position_seg_type in hr_organization_information.org_information18%type)

Line 3489: c_legal_entity_id hr_organization_units.organization_id%type,

3485: ---------------------------------------------------------------------------
3486: cursor grade
3487: ( c_person_id per_all_people_f.person_id%type,
3488: c_assignment_id per_assignments_f.assignment_id%type,
3489: c_legal_entity_id hr_organization_units.organization_id%type,
3490: c_basis_start date,
3491: c_basis_end date) is
3492:
3493: select grade.name

Line 3523: c_legal_entity_id hr_organization_units.organization_id%type,

3519: ---------------------------------------------------------------------------
3520: cursor job
3521: ( c_person_id per_all_people_f.person_id%type,
3522: c_assignment_id per_all_assignments_f.assignment_id%type,
3523: c_legal_entity_id hr_organization_units.organization_id%type,
3524: c_basis_start date,
3525: c_basis_end date) is
3526:
3527: select jbt.name

Line 3558: c_legal_entity_id hr_organization_units.organization_id%type,

3554: ---------------------------------------------------------------------------
3555: cursor position
3556: ( c_person_id per_all_people_f.person_id%type,
3557: c_assignment_id per_all_assignments_f.assignment_id%type,
3558: c_legal_entity_id hr_organization_units.organization_id%type,
3559: c_basis_start date,
3560: c_basis_end date) is
3561:
3562: select pst.name

Line 3598: c_legal_entity_id hr_organization_units.organization_id%type,

3594: ( c_person_id per_all_people_f.person_id%type,
3595: c_assignment_id per_all_assignments_f.assignment_id%type,
3596: c_basis_start date,
3597: c_basis_end date,
3598: c_legal_entity_id hr_organization_units.organization_id%type,
3599: c_er_position_seg_type hr_organization_information.org_information18
3600: %type) is
3601:
3602: select decode(fifs.application_column_name, 'SEGMENT1', ppd.segment1,

Line 3637: hr_organization_units hou,

3633: hr_soft_coding_keyflex hsc,
3634: hr_all_positions_f pos,
3635: hr_all_positions_f_tl pst,
3636: per_position_definitions ppd,
3637: hr_organization_units hou,
3638: hr_organization_information hoi,
3639: fnd_id_flex_segments fifs,
3640: fnd_id_flex_structures fift
3641: where assign.person_id = c_person_id

Line 3685: c_legal_entity_id hr_organization_units.organization_id%type,

3681:
3682: cursor other
3683: ( c_person_id per_all_people_f.person_id%type,
3684: c_assignment_id per_all_assignments_f.assignment_id%type,
3685: c_legal_entity_id hr_organization_units.organization_id%type,
3686: c_basis_start date,
3687: c_basis_end date) is
3688:
3689: select /*+ USE_NL(aei) */

Line 3773: p_legal_entity_id in hr_organization_units.organization_id%type,

3769: ---------------------------------------------------------------------------
3770: procedure archive_os_assignment
3771: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3772: p_person_id in per_all_people_f.person_id%type,
3773: p_legal_entity_id in hr_organization_units.organization_id%type,
3774: p_basis_start in date,
3775: p_basis_end in date )
3776: is
3777: --

Line 3791: c_legal_entity_id hr_organization_units.organization_id%type,

3787: -- Bug# 4688761 - Modified cursor to check the legal entity
3788: ---------------------------------------------------------------------------
3789: cursor os_assignment
3790: ( c_person_id per_all_people_f.person_id%type,
3791: c_legal_entity_id hr_organization_units.organization_id%type,
3792: c_basis_start date,
3793: c_basis_end date )
3794: is
3795: select aei.aei_information1,