DBA Data[Home] [Help]

APPS.PAY_US_MAGTAPE_REPORTING dependencies on PAY_STATE_RULES

Line 102: from pay_state_rules SR

98: -- Get the jurisdiction_code for the specified state code.
99: --
100: cursor csr_jurisdiction_code is
101: select SR.jurisdiction_code
102: from pay_state_rules SR
103: where SR.state_code = p_state;
104: --
105: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
106: --

Line 105: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;

101: select SR.jurisdiction_code
102: from pay_state_rules SR
103: where SR.state_code = p_state;
104: --
105: l_jurisdiction_code pay_state_rules.jurisdiction_code%type;
106: --
107: begin
108: --
109: hr_utility.set_location('pay_us_magtape_reporting.lookup_jurisdiction_code - opening cursor', 1);

Line 650: pay_state_rules SR,

646: FROM per_assignments_f ASG,
647: hr_soft_coding_keyflex SCL,
648: hr_tax_units_v TUV,
649: pay_payrolls_f PPY,
650: pay_state_rules SR,
651: pay_element_types_f ET,
652: pay_input_values_f IV,
653: pay_element_links_f EL
654: WHERE ASG.business_group_id + 0 = l_bus_group_id