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_PAYRG_PKG dependencies on PAY_PAYRG_PKG

Line 55: pay_payrg_pkg to pay_ca_payrg_pkg

51: 28-AUG-2002 tclewis 115.2 Modified the action creation cursor
52: for the umbrella process and for
53: multiple assignment processing.
54: 30-MAR-2001 jgoswami 115.1 Changed package name from
55: pay_payrg_pkg to pay_ca_payrg_pkg
56: as it was conflicting with pypayreg.pkb
57: 29-OCT-1999 jgoswami 110.0 Created based on pypayreg.pkb 110.1 99/08/04 rthakur
58: Original file pypayreg.pkb info
59: 09-MAR-1999 meshah 40.0 created

Line 89: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)

85: pay_payroll_actions ppa, /* PYUGEN information */
86: pay_payroll_actions pa1 /* Payroll Register information */
87: where ppa.payroll_action_id = :payroll_action_id
88: and pa1.consolidation_set_id =
89: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)
90: and pa1.payroll_id =
91: nvl(pay_payrg_pkg.get_parameter(''PY_ID'',ppa.legislative_parameters),pa1.payroll_id)
92: and pa1.effective_date between /* date join btwn payreg and pyugen ppa */
93: ppa.start_date and ppa.effective_date

Line 91: nvl(pay_payrg_pkg.get_parameter(''PY_ID'',ppa.legislative_parameters),pa1.payroll_id)

87: where ppa.payroll_action_id = :payroll_action_id
88: and pa1.consolidation_set_id =
89: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)
90: and pa1.payroll_id =
91: nvl(pay_payrg_pkg.get_parameter(''PY_ID'',ppa.legislative_parameters),pa1.payroll_id)
92: and pa1.effective_date between /* date join btwn payreg and pyugen ppa */
93: ppa.start_date and ppa.effective_date
94: and pa1.payroll_action_id = act.payroll_action_id
95: and asg.assignment_id = act.assignment_id

Line 106: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)

102: and act2.payroll_action_id = ppa2.payroll_action_id
103: and ppa2.action_type in (''R'',''Q'')
104: and act2.action_status = ''C''
105: and act2.tax_unit_id =
106: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)
107: and asg.organization_id =
108: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
109: and asg.location_id =
110: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)

Line 108: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)

104: and act2.action_status = ''C''
105: and act2.tax_unit_id =
106: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)
107: and asg.organization_id =
108: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
109: and asg.location_id =
110: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
111: and asg.person_id =
112: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)

Line 110: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)

106: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)
107: and asg.organization_id =
108: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
109: and asg.location_id =
110: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
111: and asg.person_id =
112: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)
113: and asg.business_group_id +0 =
114: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)

Line 112: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)

108: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
109: and asg.location_id =
110: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
111: and asg.person_id =
112: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)
113: and asg.business_group_id +0 =
114: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)
115: order by asg.person_id';
116:

Line 114: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)

110: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
111: and asg.person_id =
112: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)
113: and asg.business_group_id +0 =
114: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)
115: order by asg.person_id';
116:
117:
118: end range_cursor;

Line 393: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),

389: prev_tax_unit_id := 0;
390: prev_source_action_id := 0;
391:
392: select legislative_parameters, business_group_id,
393: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),

Line 394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),

390: prev_source_action_id := 0;
391:
392: select legislative_parameters, business_group_id,
393: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),

Line 395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),

391:
392: select legislative_parameters, business_group_id,
393: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
399: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))

Line 396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),

392: select legislative_parameters, business_group_id,
393: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
399: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
400: into l_leg_param, ln_busi_grp_id,

Line 397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),

393: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
399: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
400: into l_leg_param, ln_busi_grp_id,
401: ln_leg_payroll_id,

Line 398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),

394: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
399: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
400: into l_leg_param, ln_busi_grp_id,
401: ln_leg_payroll_id,
402: ln_leg_cons_set_id,

Line 399: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))

395: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
396: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
397: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
398: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
399: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
400: into l_leg_param, ln_busi_grp_id,
401: ln_leg_payroll_id,
402: ln_leg_cons_set_id,
403: ln_leg_tax_unit_id,

Line 435: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);

431: ln_leg_org_id,
432: ln_leg_loc_id,
433: ln_leg_person_id);
434:
435: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
436:
437: num := 0;
438: loop
439: hr_utility.set_location('procpyr',2);

Line 788: decode(pay_payrg_pkg.get_parameter(''P_S1'',ppa1.legislative_parameters),

784: and ppf.person_id = paf.person_id
785: and ppa1.effective_date between
786: ppf.effective_start_date and ppf.effective_end_date
787: order by
788: decode(pay_payrg_pkg.get_parameter(''P_S1'',ppa1.legislative_parameters),
789: ''GRE'',hou1.name,
790: ''ORGANIZATION'',hou.name,
791: ''LOCATION'',loc.location_code,null),
792: decode(pay_payrg_pkg.get_parameter(''P_S2'',ppa1.legislative_parameters),

Line 792: decode(pay_payrg_pkg.get_parameter(''P_S2'',ppa1.legislative_parameters),

788: decode(pay_payrg_pkg.get_parameter(''P_S1'',ppa1.legislative_parameters),
789: ''GRE'',hou1.name,
790: ''ORGANIZATION'',hou.name,
791: ''LOCATION'',loc.location_code,null),
792: decode(pay_payrg_pkg.get_parameter(''P_S2'',ppa1.legislative_parameters),
793: ''GRE'',hou1.name,
794: ''ORGANIZATION'',hou.name,
795: ''LOCATION'',loc.location_code,null),
796: decode(pay_payrg_pkg.get_parameter(''P_S3'',ppa1.legislative_parameters),

Line 796: decode(pay_payrg_pkg.get_parameter(''P_S3'',ppa1.legislative_parameters),

792: decode(pay_payrg_pkg.get_parameter(''P_S2'',ppa1.legislative_parameters),
793: ''GRE'',hou1.name,
794: ''ORGANIZATION'',hou.name,
795: ''LOCATION'',loc.location_code,null),
796: decode(pay_payrg_pkg.get_parameter(''P_S3'',ppa1.legislative_parameters),
797: ''GRE'',hou1.name,
798: ''ORGANIZATION'',hou.name,
799: ''LOCATION'',loc.location_code,null),
800: hou.name,ppf.full_name