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

Line 207: pay_assignment_actions and not

203: information thro' the
204: package and not thro' the formula.
205: 15-AUG-2002 asasthan 115.40 2200920 Changed Range Cursor to go off
206: tax_unit_id of
207: pay_assignment_actions and not
208: hr_soft_coding_keyflex
209: 2503639 Archiving Territory Balances
210: with Dimension of PER_GRE_YTD
211: and not PER_JD_GRE_YTD.

Line 215: PAY_ASSIGNMENT_ACTIONS_N51 instead

211: and not PER_JD_GRE_YTD.
212: 18-JUN-2002 ahanda 115.39 2412644 Correct Hint Syntax.
213: 01-APR-2002 asasthan 115.38 2249870 modified Index Hint addded in
214: 115.36 to use
215: PAY_ASSIGNMENT_ACTIONS_N51 instead
216: of PAY_ASSIGNMENT_ACTIONS_N1
217: 22-JAN-2002 jgoswami 115.37 added checkfile command
218: 28-DEC-2001 jgoswami 115.36 2161771 Added Index Hint in exist part of
219: the sql statement for c_eoy_gre in

Line 216: of PAY_ASSIGNMENT_ACTIONS_N1

212: 18-JUN-2002 ahanda 115.39 2412644 Correct Hint Syntax.
213: 01-APR-2002 asasthan 115.38 2249870 modified Index Hint addded in
214: 115.36 to use
215: PAY_ASSIGNMENT_ACTIONS_N51 instead
216: of PAY_ASSIGNMENT_ACTIONS_N1
217: 22-JAN-2002 jgoswami 115.37 added checkfile command
218: 28-DEC-2001 jgoswami 115.36 2161771 Added Index Hint in exist part of
219: the sql statement for c_eoy_gre in
220: eoy_action_creation procedure.

Line 323: tax_unit_name from pay_assignment_actions.

319: 30-dec-1998 vmehta 40.20 709641 Look at SUI_ER_SUBJ_WHABLE instead of SUI_ER_GROSS
320: for picking up people for SQWL . This makes sure
321: that only people with SUI wages are picked up.
322: 27-dec-1998 vmehta 40.19 Corrected the cursor in action creation to get the
323: tax_unit_name from pay_assignment_actions.
324: 21-DEC-1998 achauhan 40.18 Changed the cursor in action creation to get the
325: assignments from the pay_assignment_actions table.
326:
327: 08-DEC-1998 vmehta 40.17 Removed grouping by on assignment_id while creating

Line 325: assignments from the pay_assignment_actions table.

321: that only people with SUI wages are picked up.
322: 27-dec-1998 vmehta 40.19 Corrected the cursor in action creation to get the
323: tax_unit_name from pay_assignment_actions.
324: 21-DEC-1998 achauhan 40.18 Changed the cursor in action creation to get the
325: assignments from the pay_assignment_actions table.
326:
327: 08-DEC-1998 vmehta 40.17 Removed grouping by on assignment_id while creating
328: assignment_ids
329: 08-DEC-1998 nbristow 40.16 Updated the c_state cursor to use

Line 1129: l_primary_asg pay_assignment_actions.assignment_id%type;

1125: l_eoy_tax_unit_id number;
1126: l_effective_date date;
1127: l_bus_group_id number;
1128:
1129: l_primary_asg pay_assignment_actions.assignment_id%type;
1130: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
1131:
1132: /* Variables used to check if RANGE_PERSON_ID is enabled */
1133: l_range_person BOOLEAN;

Line 1130: l_bal_aaid pay_assignment_actions.assignment_action_id%type;

1126: l_effective_date date;
1127: l_bus_group_id number;
1128:
1129: l_primary_asg pay_assignment_actions.assignment_id%type;
1130: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
1131:
1132: /* Variables used to check if RANGE_PERSON_ID is enabled */
1133: l_range_person BOOLEAN;
1134:

Line 1167: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

1163: ASG.person_id person_id
1164: FROM per_all_assignments_f ASG,
1165: pay_all_payrolls_f PPY
1166: WHERE exists
1167: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1168: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1169: 'x'
1170: from pay_payroll_actions ppa,
1171: pay_assignment_actions paa

Line 1171: pay_assignment_actions paa

1167: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1168: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1169: 'x'
1170: from pay_payroll_actions ppa,
1171: pay_assignment_actions paa
1172: where ppa.effective_date between cp_period_start
1173: and cp_period_end
1174: and ppa.action_type in ('R','Q','V','B','I')
1175: and ppa.action_status = 'C'

Line 1200: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

1196: from pay_population_ranges ppr,
1197: per_all_assignments_f asg,
1198: pay_all_payrolls_f ppy
1199: where exists
1200: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1201: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1202: 'x'
1203: from pay_payroll_actions ppa,
1204: pay_assignment_actions paa

Line 1204: pay_assignment_actions paa

1200: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1201: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1202: 'x'
1203: from pay_payroll_actions ppa,
1204: pay_assignment_actions paa
1205: where ppa.effective_date between cp_period_start
1206: and cp_period_end
1207: and ppa.action_type in ('R','Q','V','B','I')
1208: and ppa.action_status = 'C'

Line 1253: from pay_assignment_actions paa,

1249: ,cp_period_start in date
1250: ,cp_period_end in date) IS
1251: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
1252: ||lpad(paa.assignment_action_id,15,'0')),16))
1253: from pay_assignment_actions paa,
1254: per_all_assignments_f paf,
1255: pay_payroll_actions ppa,
1256: pay_action_classifications pac
1257: where paf.person_id = cp_person_id

Line 1455: select pay_assignment_actions_s.nextval

1451: end if;
1452:
1453: /* Create the assignment action to represnt the person / tax unit
1454: combination. */
1455: select pay_assignment_actions_s.nextval
1456: into lockingactid
1457: from dual;
1458:
1459: /* Insert into pay_assignment_actions. */

Line 1459: /* Insert into pay_assignment_actions. */

1455: select pay_assignment_actions_s.nextval
1456: into lockingactid
1457: from dual;
1458:
1459: /* Insert into pay_assignment_actions. */
1460: hr_utility.trace('creating asg action');
1461:
1462: hr_nonrun_asact.insact(lockingactid,l_primary_asg,
1463: pactid,chunk,l_tax_unit_id);

Line 1471: update pay_assignment_actions aa

1467: to do an additional checking against the assignment
1468: table */
1469: hr_utility.trace('updating asg action');
1470:
1471: update pay_assignment_actions aa
1472: set aa.serial_number = to_char(l_person_id)
1473: where aa.assignment_action_id = lockingactid;
1474:
1475: end if; /* l_value <> 0 */

Line 2626: from pay_assignment_actions paa

2622: ln_year NUMBER := 0;
2623:
2624: cursor c_get_min_chunk is
2625: select min(paa.chunk_number)
2626: from pay_assignment_actions paa
2627: where paa.payroll_action_id = p_payroll_action_id;
2628:
2629:
2630: begin

Line 2974: l_aaid pay_assignment_actions.assignment_action_id%type;

2970: */
2971:
2972: procedure eoy_archive_data(p_assactid in number, p_effective_date in date) is
2973:
2974: l_aaid pay_assignment_actions.assignment_action_id%type;
2975: l_aaseq pay_assignment_actions.action_sequence%type;
2976: l_asgid pay_assignment_actions.assignment_id%type;
2977: l_date_earned date;
2978: l_taxunitid pay_assignment_actions.tax_unit_id%type;

Line 2975: l_aaseq pay_assignment_actions.action_sequence%type;

2971:
2972: procedure eoy_archive_data(p_assactid in number, p_effective_date in date) is
2973:
2974: l_aaid pay_assignment_actions.assignment_action_id%type;
2975: l_aaseq pay_assignment_actions.action_sequence%type;
2976: l_asgid pay_assignment_actions.assignment_id%type;
2977: l_date_earned date;
2978: l_taxunitid pay_assignment_actions.tax_unit_id%type;
2979: l_year_start date;

Line 2976: l_asgid pay_assignment_actions.assignment_id%type;

2972: procedure eoy_archive_data(p_assactid in number, p_effective_date in date) is
2973:
2974: l_aaid pay_assignment_actions.assignment_action_id%type;
2975: l_aaseq pay_assignment_actions.action_sequence%type;
2976: l_asgid pay_assignment_actions.assignment_id%type;
2977: l_date_earned date;
2978: l_taxunitid pay_assignment_actions.tax_unit_id%type;
2979: l_year_start date;
2980: l_year_end date;

Line 2978: l_taxunitid pay_assignment_actions.tax_unit_id%type;

2974: l_aaid pay_assignment_actions.assignment_action_id%type;
2975: l_aaseq pay_assignment_actions.action_sequence%type;
2976: l_asgid pay_assignment_actions.assignment_id%type;
2977: l_date_earned date;
2978: l_taxunitid pay_assignment_actions.tax_unit_id%type;
2979: l_year_start date;
2980: l_year_end date;
2981: l_context_no number := 60;
2982: l_count number := 0;

Line 3160: from pay_assignment_actions paa,

3156: -- associated with Maximum Action Sequence
3157: CURSOR c_get_latest_asg(p_person_id number ) IS
3158: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
3159: ||lpad(paa.assignment_action_id,15,'0')),16))
3160: from pay_assignment_actions paa,
3161: per_all_assignments_f paf,
3162: pay_payroll_actions ppa,
3163: pay_action_classifications pac
3164: where paf.person_id = p_person_id

Line 3237: FROM pay_assignment_actions BAL_ASSACT

3233: CURSOR c_prior_def_yr_roth(cp_asg_act_id IN NUMBER
3234: ,cp_asg_id IN NUMBER
3235: ,cp_ele_info1 IN VARCHAR2) IS
3236: SELECT TARGET.result_value
3237: FROM pay_assignment_actions BAL_ASSACT
3238: , pay_payroll_actions BACT
3239: , per_all_assignments_f ASS
3240: , pay_assignment_actions ASSACT
3241: , pay_payroll_actions PACT

Line 3240: , pay_assignment_actions ASSACT

3236: SELECT TARGET.result_value
3237: FROM pay_assignment_actions BAL_ASSACT
3238: , pay_payroll_actions BACT
3239: , per_all_assignments_f ASS
3240: , pay_assignment_actions ASSACT
3241: , pay_payroll_actions PACT
3242: , pay_run_results RR
3243: , pay_run_result_values TARGET
3244: , pay_input_values_f PIV

Line 3300: FROM pay_assignment_actions aa

3296: l_taxunitid,
3297: l_chunk,
3298: l_payroll_action_id,
3299: l_person_id
3300: FROM pay_assignment_actions aa
3301: WHERE aa.assignment_action_id = p_assactid;
3302:
3303: /* If the chunk of the assignment is same as the minimun chunk
3304: for the payroll_action_id and the gre data has not yet been