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_CA_EOY_RL1_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1049: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

1045: that are created. */
1046:
1047: l_payroll_action_created boolean := false;
1048: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1049: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1050: l_archive_item_id number;
1051:
1052: /* Variable holding the balance to be tested. */
1053:

Line 1101: l_primary_asg pay_assignment_actions.assignment_id%type;

1097: lockingactid number;
1098: l_max_aaid number;
1099: l_pre_organization_id varchar2(17);
1100: l_prev_pre_organization_id varchar2(17);
1101: l_primary_asg pay_assignment_actions.assignment_id%type;
1102: ln_no_gross_earnings number;
1103: ln_nontaxable_earnings number;
1104:
1105:

Line 1155: pay_assignment_actions paa,

1151: SELECT asg.person_id person_id,
1152: asg.assignment_id assignment_id,
1153: asg.effective_end_date effective_end_date
1154: FROM per_all_assignments_f asg,
1155: pay_assignment_actions paa,
1156: pay_payroll_actions ppa
1157: WHERE ppa.effective_date between l_period_start
1158: and l_period_end
1159: AND ppa.action_type in ('R','Q','V','B','I')

Line 1191: pay_assignment_actions paa,

1187: SELECT asg.person_id person_id,
1188: asg.assignment_id assignment_id,
1189: asg.effective_end_date effective_end_date
1190: FROM per_all_assignments_f asg,
1191: pay_assignment_actions paa,
1192: pay_payroll_actions ppa,
1193: pay_population_ranges ppr
1194: WHERE ppa.effective_date between l_period_start
1195: and l_period_end

Line 1248: from pay_assignment_actions paa,

1244: cp_tax_unit_id number,
1245: cp_period_start date,
1246: cp_period_end date) IS
1247: select paa.assignment_action_id
1248: from pay_assignment_actions paa,
1249: per_all_assignments_f paf,
1250: per_all_people_f ppf,
1251: pay_payroll_actions ppa,
1252: pay_action_classifications pac

Line 1513: select pay_assignment_actions_s.nextval

1509:
1510: /* Create the assignment action to represnt the person / tax unit
1511: combination. */
1512:
1513: select pay_assignment_actions_s.nextval
1514: into lockingactid
1515: from dual;
1516:
1517: /* Insert into pay_assignment_actions. */

Line 1517: /* Insert into pay_assignment_actions. */

1513: select pay_assignment_actions_s.nextval
1514: into lockingactid
1515: from dual;
1516:
1517: /* Insert into pay_assignment_actions. */
1518:
1519: hr_utility.trace('creating assignment action');
1520:
1521: /* Passing tax unit id as null */

Line 1533: update pay_assignment_actions aa

1529: table */
1530:
1531: hr_utility.trace('updating assignment action' || to_char(lockingactid));
1532:
1533: update pay_assignment_actions aa
1534: set aa.serial_number = to_char(l_person_id)
1535: where aa.assignment_action_id = lockingactid;
1536:
1537:

Line 2147: from pay_assignment_actions paa

2143: l_step number := 0;
2144:
2145: cursor c_get_min_chunk is
2146: select min(paa.chunk_number)
2147: from pay_assignment_actions paa
2148: where paa.payroll_action_id = p_payroll_action_id;
2149: begin
2150: open c_get_min_chunk;
2151: fetch c_get_min_chunk into g_min_chunk;

Line 2442: l_aaid pay_assignment_actions.assignment_action_id%type;

2438: p_effective_date in date,
2439: p_negative_balance_exists in out NOCOPY varchar2,
2440: p_temp_nz_fi in out NOCOPY number) IS /*Bug 13564765 sbachu*/
2441:
2442: l_aaid pay_assignment_actions.assignment_action_id%type;
2443: l_asgid pay_assignment_actions.assignment_id%type;
2444: l_date_earned date;
2445: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2446: l_business_group_id number;

Line 2443: l_asgid pay_assignment_actions.assignment_id%type;

2439: p_negative_balance_exists in out NOCOPY varchar2,
2440: p_temp_nz_fi in out NOCOPY number) IS /*Bug 13564765 sbachu*/
2441:
2442: l_aaid pay_assignment_actions.assignment_action_id%type;
2443: l_asgid pay_assignment_actions.assignment_id%type;
2444: l_date_earned date;
2445: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2446: l_business_group_id number;
2447: l_year_start date;

Line 2445: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

2441:
2442: l_aaid pay_assignment_actions.assignment_action_id%type;
2443: l_asgid pay_assignment_actions.assignment_id%type;
2444: l_date_earned date;
2445: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2446: l_business_group_id number;
2447: l_year_start date;
2448: l_year_end date;
2449: l_count number := 0;

Line 2470: pay_assignment_actions paa,

2466: ) IS
2467: select /*+ Ordered */ paa.assignment_action_id
2468: from per_all_people_f ppf,
2469: per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,
2474: ff_contexts fc

Line 2496: pay_assignment_actions paa,

2492:
2493: cursor c_all_gres_for_further_info(asgactid number) is
2494: select hoi.organization_id
2495: from pay_payroll_actions ppa,
2496: pay_assignment_actions paa,
2497: hr_organization_information hoi
2498: where paa.assignment_action_id = asgactid
2499: and ppa.payroll_action_id = paa.payroll_action_id
2500: and hoi.org_information2 =

Line 2527: FROM pay_assignment_actions aa

2523: l_tax_unit_id,
2524: l_chunk,
2525: l_payroll_action_id,
2526: lv_serial_number
2527: FROM pay_assignment_actions aa
2528: WHERE aa.assignment_action_id = p_assactid;
2529:
2530: /* If the chunk of the assignment is same as the minimun chunk
2531: for the payroll_action_id and the gre data has not yet been

Line 2794: l_aaid pay_assignment_actions.assignment_action_id%type;

2790:
2791: PROCEDURE eoy_archive_data(p_assactid in number,
2792: p_effective_date in date) IS
2793:
2794: l_aaid pay_assignment_actions.assignment_action_id%type;
2795: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2796: l_aaseq pay_assignment_actions.action_sequence%type;
2797: l_asgid pay_assignment_actions.assignment_id%type;
2798: l_date_earned date;

Line 2795: l_aaid1 pay_assignment_actions.assignment_action_id%type;

2791: PROCEDURE eoy_archive_data(p_assactid in number,
2792: p_effective_date in date) IS
2793:
2794: l_aaid pay_assignment_actions.assignment_action_id%type;
2795: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2796: l_aaseq pay_assignment_actions.action_sequence%type;
2797: l_asgid pay_assignment_actions.assignment_id%type;
2798: l_date_earned date;
2799: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

Line 2796: l_aaseq pay_assignment_actions.action_sequence%type;

2792: p_effective_date in date) IS
2793:
2794: l_aaid pay_assignment_actions.assignment_action_id%type;
2795: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2796: l_aaseq pay_assignment_actions.action_sequence%type;
2797: l_asgid pay_assignment_actions.assignment_id%type;
2798: l_date_earned date;
2799: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2800: l_reporting_type varchar2(240);

Line 2797: l_asgid pay_assignment_actions.assignment_id%type;

2793:
2794: l_aaid pay_assignment_actions.assignment_action_id%type;
2795: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2796: l_aaseq pay_assignment_actions.action_sequence%type;
2797: l_asgid pay_assignment_actions.assignment_id%type;
2798: l_date_earned date;
2799: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2800: l_reporting_type varchar2(240);
2801: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;

Line 2799: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

2795: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2796: l_aaseq pay_assignment_actions.action_sequence%type;
2797: l_asgid pay_assignment_actions.assignment_id%type;
2798: l_date_earned date;
2799: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2800: l_reporting_type varchar2(240);
2801: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
2802: l_business_group_id number;
2803: l_year_start date;

Line 2801: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;

2797: l_asgid pay_assignment_actions.assignment_id%type;
2798: l_date_earned date;
2799: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2800: l_reporting_type varchar2(240);
2801: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
2802: l_business_group_id number;
2803: l_year_start date;
2804: l_year_end date;
2805: l_context_no number := 60;

Line 2904: l_ft_aaid pay_assignment_actions.assignment_action_id%type;

2900: ln_boxo_exclude_from_boxa NUMBER := 0;
2901: lv_footnote_bal varchar2(80);
2902:
2903: /* added these 3 new variables for 11510 changes bug#3356533 */
2904: l_ft_aaid pay_assignment_actions.assignment_action_id%type;
2905: l_ft_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2906: l_ft_reporting_type varchar2(240);
2907: lv_serial_number varchar2(30);
2908:

Line 2905: l_ft_tax_unit_id pay_assignment_actions.tax_unit_id%type;

2901: lv_footnote_bal varchar2(80);
2902:
2903: /* added these 3 new variables for 11510 changes bug#3356533 */
2904: l_ft_aaid pay_assignment_actions.assignment_action_id%type;
2905: l_ft_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2906: l_ft_reporting_type varchar2(240);
2907: lv_serial_number varchar2(30);
2908:
2909: /* new variables added for Provincial YE Amendment PP */

Line 2957: pay_assignment_actions paa,

2953: cursor c_all_gres(asgactid number) is
2954: select hoi.organization_id ,
2955: hoi.org_information5
2956: from pay_payroll_actions ppa,
2957: pay_assignment_actions paa,
2958: hr_organization_information hoi
2959: where paa.assignment_action_id = asgactid
2960: and ppa.payroll_action_id = paa.payroll_action_id
2961: and hoi.org_information2 =

Line 2972: pay_assignment_actions paa,

2968: cursor c_all_gres_for_footnote(asgactid number) is
2969: select hoi.organization_id ,
2970: hoi.org_information5
2971: from pay_payroll_actions ppa,
2972: pay_assignment_actions paa,
2973: hr_organization_information hoi
2974: where paa.assignment_action_id = asgactid
2975: and ppa.payroll_action_id = paa.payroll_action_id
2976: and hoi.org_information2 =

Line 2992: from pay_assignment_actions paa,

2988: Using assignment_id instead of assignment_action_id
2989: */
2990: cursor c_all_gres_for_person(cp_asg_id number,cp_eff_date date) is
2991: select distinct paa.tax_unit_id
2992: from pay_assignment_actions paa,
2993: pay_payroll_actions ppa,
2994: per_all_assignments_f paf
2995: where paa.assignment_id = cp_asg_id
2996: and paf.assignment_id = cp_asg_id

Line 3076: , pay_assignment_actions run_paa

3072: , pay_run_results prr
3073: , pay_element_types_f pet
3074: , pay_input_values_f piv1
3075: , pay_input_values_f piv2
3076: , pay_assignment_actions run_paa
3077: , pay_payroll_actions run_ppa
3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf

Line 3078: , pay_assignment_actions arch_paa

3074: , pay_input_values_f piv1
3075: , pay_input_values_f piv2
3076: , pay_assignment_actions run_paa
3077: , pay_payroll_actions run_ppa
3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf
3082: , hr_all_organization_units hou

Line 3156: from pay_payroll_actions ppa,pay_assignment_actions paa

3152: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';
3153:
3154: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
3155: select ppa.report_type
3156: from pay_payroll_actions ppa,pay_assignment_actions paa
3157: where paa.assignment_action_id = cp_locked_actid
3158: and ppa.payroll_action_id = paa.payroll_action_id;
3159:
3160: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 3186: pay_assignment_actions paa,

3182: ) IS
3183: select /*+ Ordered */ paa.assignment_action_id
3184: from per_all_people_f ppf,
3185: per_all_assignments_f paf,
3186: pay_assignment_actions paa,
3187: pay_payroll_actions ppa,
3188: pay_action_classifications pac,
3189: pay_action_contexts pac1,
3190: ff_contexts fc

Line 3216: from pay_assignment_actions paa,

3212: cp_tax_unit_id number,
3213: cp_period_start date,
3214: cp_period_end date) IS
3215: select paa.assignment_action_id
3216: from pay_assignment_actions paa,
3217: per_all_assignments_f paf,
3218: per_all_people_f ppf,
3219: pay_payroll_actions ppa,
3220: pay_action_classifications pac

Line 3257: FROM pay_assignment_actions aa

3253: l_tax_unit_id,
3254: l_chunk,
3255: l_payroll_action_id,
3256: lv_serial_number
3257: FROM pay_assignment_actions aa
3258: WHERE aa.assignment_action_id = p_assactid;
3259:
3260: /* If the chunk of the assignment is same as the minimun chunk
3261: for the payroll_action_id and the gre data has not yet been

Line 5122: pay_assignment_actions paa,

5118:
5119: sqlstr := 'select distinct asg.person_id
5120: from pay_all_payrolls_f ppy,
5121: pay_payroll_actions ppa,
5122: pay_assignment_actions paa,
5123: per_all_assignments_f asg,
5124: pay_payroll_actions ppa1
5125: where ppa1.payroll_action_id = :payroll_action_id
5126: and ppa.effective_date between