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_FR_PTO_PKG dependencies on PER_CONTRACTS_F

Line 5676: per_contracts_f pcf

5672: l_valid varchar2(10);
5673: cursor csr_find_match is
5674: select 'TRUE'
5675: from per_all_assignments_f asg,
5676: per_contracts_f pcf
5677: where p_date_earned >= asg.effective_start_date
5678: and p_assignment_id = asg.assignment_id
5679: and asg.contract_id = pcf.contract_id
5680: and p_date_earned between pcf.effective_start_date

Line 5704: l_contract_id per_contracts_f.contract_id%TYPE;

5700: (p_assignment_id in number
5701: ,p_date_earned in date
5702: ,p_reference in varchar2) /* entry ref input value */
5703: return date is
5704: l_contract_id per_contracts_f.contract_id%TYPE;
5705: l_contract_status per_contracts_f.status%TYPE;
5706: --
5707: cursor csr_get_contract_details is
5708: select pcf.contract_id, pcf.status

Line 5705: l_contract_status per_contracts_f.status%TYPE;

5701: ,p_date_earned in date
5702: ,p_reference in varchar2) /* entry ref input value */
5703: return date is
5704: l_contract_id per_contracts_f.contract_id%TYPE;
5705: l_contract_status per_contracts_f.status%TYPE;
5706: --
5707: cursor csr_get_contract_details is
5708: select pcf.contract_id, pcf.status
5709: from per_all_assignments_f asg,

Line 5710: per_contracts_f pcf

5706: --
5707: cursor csr_get_contract_details is
5708: select pcf.contract_id, pcf.status
5709: from per_all_assignments_f asg,
5710: per_contracts_f pcf
5711: where p_assignment_id = asg.assignment_id
5712: and asg.contract_id = pcf.contract_id
5713: and p_date_earned >= asg.effective_start_date
5714: and p_date_earned between pcf.effective_start_date

Line 6097: from per_contracts_f

6093: -- Added new cursors for bugs 4099667 and 4103779.
6094: -- Modified cursor to find contract category
6095: cursor csr_contr_change_catg(c_contract_id per_all_assignments_f.contract_id%TYPE) is
6096: select effective_start_date, ctr_information2 con_catg
6097: from per_contracts_f
6098: where contract_id=c_contract_id
6099: and ctr_information_category = 'FR';
6100:
6101: cursor csr_contr_max_end(c_contract_id per_all_assignments_f.contract_id%TYPE) is

Line 6103: from per_contracts_f contr

6099: and ctr_information_category = 'FR';
6100:
6101: cursor csr_contr_max_end(c_contract_id per_all_assignments_f.contract_id%TYPE) is
6102: select max(effective_end_date)
6103: from per_contracts_f contr
6104: where contract_id=c_contract_id;
6105:
6106: l_csr_min_effect_start_date csr_min_effect_start_date%rowtype;
6107: l_csr_fnd_contract_id csr_fnd_contract_id%rowtype;

Line 6203: per_contracts_f con

6199: Select decode(con.ctr_information12,'HOUR', con.ctr_information13, asg.frequency) frequency,
6200: decode(con.ctr_information12,'HOUR', fnd_number.canonical_to_number(con.ctr_information11), asg.normal_hours) hours,
6201: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_effective_date),1,1) cipdz_catg
6202: from per_all_assignments_f asg,
6203: per_contracts_f con
6204: where asg.assignment_id = p_assignment_id
6205: and asg.business_group_id = p_business_group_id
6206: and p_effective_date between
6207: asg.effective_start_date and asg.effective_end_date