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 50: pay_payrg_pkg to pay_ca_payrg_pkg

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

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

80: pay_payroll_actions ppa, /* PYUGEN information */
81: pay_payroll_actions pa1 /* Payroll Register information */
82: where ppa.payroll_action_id = :payroll_action_id
83: and pa1.consolidation_set_id =
84: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)
85: and pa1.payroll_id =
86: nvl(pay_payrg_pkg.get_parameter(''PY_ID'',ppa.legislative_parameters),pa1.payroll_id)
87: and pa1.effective_date between /* date join btwn payreg and pyugen ppa */
88: ppa.start_date and ppa.effective_date

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

82: where ppa.payroll_action_id = :payroll_action_id
83: and pa1.consolidation_set_id =
84: nvl(pay_payrg_pkg.get_parameter(''C_ST_ID'',ppa.legislative_parameters),pa1.consolidation_set_id)
85: and pa1.payroll_id =
86: nvl(pay_payrg_pkg.get_parameter(''PY_ID'',ppa.legislative_parameters),pa1.payroll_id)
87: and pa1.effective_date between /* date join btwn payreg and pyugen ppa */
88: ppa.start_date and ppa.effective_date
89: and pa1.payroll_action_id = act.payroll_action_id
90: and asg.assignment_id = act.assignment_id

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

97: and act2.payroll_action_id = ppa2.payroll_action_id
98: and ppa2.action_type in (''R'',''Q'')
99: and act2.action_status = ''C''
100: and act2.tax_unit_id =
101: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)
102: and asg.organization_id =
103: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
104: and asg.location_id =
105: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)

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

99: and act2.action_status = ''C''
100: and act2.tax_unit_id =
101: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)
102: and asg.organization_id =
103: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
104: and asg.location_id =
105: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
106: and asg.person_id =
107: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)

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

101: nvl(pay_payrg_pkg.get_parameter(''T_U_ID'',ppa.legislative_parameters), act2.tax_unit_id)
102: and asg.organization_id =
103: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
104: and asg.location_id =
105: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
106: and asg.person_id =
107: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)
108: and asg.business_group_id +0 =
109: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)

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

103: nvl(pay_payrg_pkg.get_parameter(''O_ID'',ppa.legislative_parameters), asg.organization_id)
104: and asg.location_id =
105: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
106: and asg.person_id =
107: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)
108: and asg.business_group_id +0 =
109: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)
110: order by asg.person_id';
111:

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

105: nvl(pay_payrg_pkg.get_parameter(''L_ID'',ppa.legislative_parameters), asg.location_id)
106: and asg.person_id =
107: nvl(pay_payrg_pkg.get_parameter(''P_ID'',ppa.legislative_parameters), asg.person_id)
108: and asg.business_group_id +0 =
109: pay_payrg_pkg.get_parameter(''B_G_ID'',ppa.legislative_parameters)
110: order by asg.person_id';
111:
112:
113: end range_cursor;

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

384: prev_tax_unit_id := 0;
385: prev_source_action_id := 0;
386:
387: select legislative_parameters, business_group_id,
388: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
389: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),

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

385: prev_source_action_id := 0;
386:
387: select legislative_parameters, business_group_id,
388: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
389: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
393: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),

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

386:
387: select legislative_parameters, business_group_id,
388: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
389: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
393: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))

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

387: select legislative_parameters, business_group_id,
388: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
389: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
393: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
395: into l_leg_param, ln_busi_grp_id,

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

388: to_number(pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters)),
389: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
393: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
395: into l_leg_param, ln_busi_grp_id,
396: ln_leg_payroll_id,

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

389: to_number(pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters)),
390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
393: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
395: into l_leg_param, ln_busi_grp_id,
396: ln_leg_payroll_id,
397: ln_leg_cons_set_id,

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

390: to_number(pay_payrg_pkg.get_parameter('T_U_ID', ppa.legislative_parameters)),
391: to_number(pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters)),
392: to_number(pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters)),
393: to_number(pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters)),
394: to_number(pay_payrg_pkg.get_parameter('B_G_ID', ppa.legislative_parameters))
395: into l_leg_param, ln_busi_grp_id,
396: ln_leg_payroll_id,
397: ln_leg_cons_set_id,
398: ln_leg_tax_unit_id,

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

426: ln_leg_org_id,
427: ln_leg_loc_id,
428: ln_leg_person_id);
429:
430: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
431:
432: num := 0;
433: loop
434: hr_utility.set_location('procpyr',2);

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

779: and ppf.person_id = paf.person_id
780: and ppa1.effective_date between
781: ppf.effective_start_date and ppf.effective_end_date
782: order by
783: decode(pay_payrg_pkg.get_parameter(''P_S1'',ppa1.legislative_parameters),
784: ''GRE'',hou1.name,
785: ''ORGANIZATION'',hou.name,
786: ''LOCATION'',loc.location_code,null),
787: decode(pay_payrg_pkg.get_parameter(''P_S2'',ppa1.legislative_parameters),

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

783: decode(pay_payrg_pkg.get_parameter(''P_S1'',ppa1.legislative_parameters),
784: ''GRE'',hou1.name,
785: ''ORGANIZATION'',hou.name,
786: ''LOCATION'',loc.location_code,null),
787: decode(pay_payrg_pkg.get_parameter(''P_S2'',ppa1.legislative_parameters),
788: ''GRE'',hou1.name,
789: ''ORGANIZATION'',hou.name,
790: ''LOCATION'',loc.location_code,null),
791: decode(pay_payrg_pkg.get_parameter(''P_S3'',ppa1.legislative_parameters),

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

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